Changing macro from absolute cell values to relative cell values

[dtanios]

Hi. I am new to macros and have just recorded a bunch on a big spreadsheet I am creating. I recorded all of the macros using Absolute cell values, but need them to be relative cell values.

Is there an easy way to convert the macros or do I just have to re-record all of them? They are quite extensive and I would like to avoid re-recording.

Any help appreciated! Thank you!

[davesexcel]

Show us a bit of code, please use code tags when showing it.