Thread: Offset by x
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] martin.a.john@gmail.com is offline
external usenet poster
 
Posts: 11
Default Offset by x

Is there a way for the offset function to work with an undefined value
i.e. offset(x , 0) from an absolute cell.

for example at the end of a loop x = x+4 to increment the offset by 4
rows on each loop.

As I have a problem with many relative references so cannot use
activecell. the offset will always start from the same fixed position.