Hi,
I've created a Worksheet_Calculate macro that fires only half the time and I can't figure out why.
It's supposed enter all the months into a worksheet range that are between the earliest and latest dates entered by the user on another worksheet. It's basically a nifty data validation trick for what will be source data for a pivot table: this macro insures that there will be no skipped months. So, if the user enters Jan, Feb and Apr (skipping Mar), the macro enters all 4 months between Jan and Apr on the database worksheet.
And if the user enters fewer months than what existed before, the macro enters all the inclusive months (the above macro fires) AND deletes the remaining months based on a simple last row needed calculation. Problem is, that calculation is correct but this macro wont fire and I don't know why. It will only fire when I manually adjust a cell on the worksheet.
Here is the Worksheet_Calculate macro:
I've also included the file. This has totally stumped me and any help would so appreciated.
Thanks,
Lawrence
Bookmarks