This is my first post and I'm new to VBA so please bear with me. My code takes several different month-end reports and formats and compiles them into one. It also pulls up last month's completed report and copies over certain tables and formatting to the new report.
Within all of these different reports, the month end dates are referenced extensively in different ways. For example 12-31-08 shows up several different times in worksheets, in file names, and in worksheet names through the code. It also references the previous month end date (11-30-08) in similar ways as well.
I've been hoping that I could just create variables like "curmonth" and "lastmonth" to reference these dates throughout the code, but after searching extensively online and in a book or two, I haven't found the best solution. I probably don't know the precise way to phrase my question.
For now I'm just doing Find and replace for each new month-end report.
Is there an easy answer?
Bookmarks