Hi everybody,
during the last week I have been writing a couple of macros for a reporting dashboard that now works as supposed.
However, knowing the way I wrote these macros, I am kind of reluctant to hand it over to the eventual users as I am afraid it will fall apart in pieces once they try to add stuff to it.
The reason for my fear is that that I hard-coded a lot of things like e.g. cell coordinates where I expect information to be; should this information or its location change, the macros will most likely not run anymore.
From previous programming experience (perl, C) I understand this is bad. And in other languages I would be more comfortable to program dynamically around it to avoid these kind of problems. However, VBA & Excel is not my strongest suit, so I am kind of lost.
Therefore my question to you: Is there descriptions/manuals/how-tos regarding "stustainable coding" - dynamic references, etc. and how to apply it? This would really make my project hand-over-ready.
Thank you very much for your help!
Best regards,
Andreas
Bookmarks