Hello,

I have a spreadsheet that is already very macro heavy.
I have now decided that it would be better if I had more rows at the
top for a summary portion
BUT
My macros are already point to cell B2 and G8, etc

How can I adjust my spreadsheet by inserting a row and column so that
the macros will now look for C3 instead of B2 and H9 instead of G8
etc.

Is there a global edit option that will pick this up or do I have to
comb through my macros manually?

PLease help