Hello,
First I have to say I am pretty new to vba programming. Now I have that problem: I made several macros on an excel worksheet that use absolute values. Can I add for example 5 rows at the start of the sheet and update macro to change it's lines-values accordingly? There are too many macros, dropdown lists, buttons and functions and made over the time (don't remember what every line means - I wasn't keeping comments so much) so it is too much and difficult work to change everything. I want to make it like it never happened (the adding of the rows) so the macro can run normally and then I can program for the new rows.
Thanks in advance
John
First I have to say I am pretty new to vba programming. Now I have that problem: I made several macros on an excel worksheet that use absolute values. Can I add for example 5 rows at the start of the sheet and update macro to change it's lines-values accordingly? There are too many macros, dropdown lists, buttons and functions and made over the time (don't remember what every line means - I wasn't keeping comments so much) so it is too much and difficult work to change everything. I want to make it like it never happened (the adding of the rows) so the macro can run normally and then I can program for the new rows.
Thanks in advance
John
