Thread: Relative Values in a Macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
  
Posts: 1,236
Default Relative Values in a Macro
This will select the cell in the next column:
Range("A1").Offset(0, 1).Select

This will select a region the same size as B5:G15 but offset 20 rows down.
Range("B5:G15").Offset(20, 0).Select



--
Rob van Gelder - http://www.vangelder.co.nz/excel


"DGernand" wrote in message
...
How do you select a range of cells with relative value instead of absolute
values in a macro?


Reply With QuoteReply With Quote