Dynamic Range Selection Using VBA

  • Thread starter Thread starter TEK
  • Start date Start date
T

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,

That did it. Thank you for your help.

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

--


Gary Keramidas
Excel 2003




.
Click to expand...
 
Back
Top