Pool Master
04-08-2008, 09:26 AM
Hi All,
I'm running into an issue with my macros and was wondering if anyone has a "best practice" that they follow to prevent this from occuring. After I finalize a macro driven report for my company they request column additions periodically. This causes me to need to revise all of my formulas and range references since everything to the right of the inserted column shifts. I know that I could cut the added columns and move them out of the table prior to running the finalized macro and insert them back in after, but this can get ugly especially when debugging the program. Does anyone have a suggestions for makes these ranges/formulas more dynamic in the macro code, so they can handle late inserted columns?
Thank you!
Adam
I'm running into an issue with my macros and was wondering if anyone has a "best practice" that they follow to prevent this from occuring. After I finalize a macro driven report for my company they request column additions periodically. This causes me to need to revise all of my formulas and range references since everything to the right of the inserted column shifts. I know that I could cut the added columns and move them out of the table prior to running the finalized macro and insert them back in after, but this can get ugly especially when debugging the program. Does anyone have a suggestions for makes these ranges/formulas more dynamic in the macro code, so they can handle late inserted columns?
Thank you!
Adam