Select Rows, based on Cell Values

[DrDave6]

Hello,

If I want to select rows 5 to 10, inclusive, I can use this statement:

Rows("5:10").Select

However, to make this more dynamic, I have stored the start row in A1 and the end row in A2.

What would the select statement look like, if I wanted it to use A1 and A2?

Also, do A1 and A2 have to be formatted as text, for this to work?

Thank you.

 

[VoG]

Try

Rows(Range("A1").Value & ":" & Range("A2").Value).Select

Cell formatting should not matter.

 

[DrDave6]

Works perfectly. Plus, being able to specify coordinates that are contained within cells opens up a world of possibilities.

Thank you.

 

[DrDave6]

A quick follow-up if I may....

What would the statement look like, if I wanted the first row to always be 16?

Thank you.

 

[VoG]

Try like this

Rows("16:" & Range("A2").Value).Select