Hi,


The below code is help to select the column B equals to the used range of column A

Range("B2:B" & Cells(Rows.Count, "a").End(xlUp).Row).Select

Similarly i would required to modify the above code select row 2 equals to the row 1 used range.

Kindly help.

Regards,

Prabhu