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

Would doing a find/replace from the edit menu in the code editor work
for this?

Comb through your macros manually would be the safest. There is a find and
replace capability in the VBE.

Many people define fixed reference points like this as constants at the top
of their module. Then in the code, they utilize the constants. When the
fixed reference points change as in your case, then they only have to change
the value of the constant at the top of the module.

--
Regards,
Tom Ogilvy



"gmunro" wrote:

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