Assume you have a cell in Excel with the formula "=D8*C6". If you now insert a row above of a column at the left of the referred cells D8 and C6, the references are automatically updated.
But if you have this line within a macro:
Sheets("MU").Cells(30, 6).Value = "100"
and you add a row on top of cell (30,6), the macro is of course not updated but now the correct line should read
Sheets("MU").Cells(31, 6).Value = "100"
So, now, I find myself in an uncomfortable position: I have lots of such references in various macros and need to insert one or two rows to make room for a checkbox that wouldn't look too nice if placed somewhere else. What could I do to avoid extra work?
Reply With Quote