Thread: Making a relative range in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Making a relative range in VBA
set rng = ActiveCell.Offset(5,4)

--
Regards,
Tom Ogilvy

aapjaap wrote in message
...
I wanted to make a relative range in VBA for excell.
Ho can i do this?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/



Reply With QuoteReply With Quote