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