Excel VBA Help

[Zobags]

I tried recording first, but it didn't work because it records the absolute position of the cell rather than the relative one. For example, if I start at A1 and move to B2 the recorded macro just says Range("B2").select. Someone on the software forum gave me the solution, but thank you anyway for your help.