View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Grace[_4_] Grace[_4_] is offline
external usenet poster
 
Posts: 106
Default Relative References for macros

I seem to need a lot of help for coding when I can't use record macro to
figure out certain things, particularly things that involve relative
movements within a worksheet. Somewhere in my very distant past, perhaps
with LOTUS, I seem to recall there was a way to record so that it would
record the relative changes (like going down 100 rows) rather than going
from row 4 to 104. Is there still such a capability with EXCEL macros. If
so, will it do the things I am thinking of?