Get 2nd parameter of ROW reference to use contents of a specific cell

[minnesota]

In VBA how do I enhance this line in a macro to use the contents of cell A1 as the end of the range?

Current:
Rows("2:200&quot.Select

Desired:
Rows("2:A1&quot.Select

I have guessed at various syntax and cannot get it to work.

Thanks very much.

 

[Mutt]

Can do somthineg like this :

temp = Range("A1&quot.Value
Rows("2:" & temp).Select

Mutt.

 

[joerd]

All you need:
Range([A2], Cells([A1].Value, 1)).EntireRow.Select


Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.