VBA Updae Cell References

Johndinho

Board Regular
Joined
Mar 21, 2013
Messages
84
Hi,

I'm sure this will be a dumb question because I'm sure I already know the answer.

I have written a dozen modules of code in a spreadsheet and now the main sheet used needs to be edited slightly. This means inserting 6 rows to it so all my code references are now out by 6 rows.

I don't really want to edit all the modules - is there a way to update them automatically the way functions do in a cell?

Or is there a way to guard against something like this happening again?

Any advice gratefully received

Thanks,
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
9,899
planning can reduce the issue, and relative referencing to static keywords might help other wise step through line by line and fix it :(
 

Forum statistics

Threads
1,082,585
Messages
5,366,466
Members
400,892
Latest member
lamarh755

Some videos you may like

This Week's Hot Topics

Top