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.
|