View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tek tek is offline
external usenet poster
 
Posts: 10
Default Dynamic Range Selection Using VBA

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.