Select till row destination

[Prabhu]

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

[Admin]

The question is not clear. Can you please elaborate little more ?

[Rick Rothstein]

I agree with Admin... your question is not entirely clear; however, let me take a guess. Is this what you are looking for...



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