Dynamic Range Selection Using VBA

[TEK]

What I'm trying to accomplish is to be able to run a procedure that selects a
range based on a number provided in another cell. For example; if the number
10 is in cell A1, then cells A20:A30 would be selected when I run the macro.
If the number 6 is provided, then cells A20:A26 would be selected. Not sure
where to start, so any help is appreciated.

 

[Gary Keramidas]

this may do what you want
range("A20").Resize(range("A1").Value+1).select

 

[TEK]

Gary,

That did it. Thank you for your help.

this may do what you want
range("A20").Resize(range("A1").Value+1).select

--


Gary Keramidas
Excel 2003




.