I've just recently upgraded from Excel 2007 to Office 365.
I've written a macro that creates unique reports for a list of recipients (store numbers), looping through until the last and popping up a message box to tell me it's complete.
Here's the code:
The code works...the problem is that it seems to shut down after building approximately 1/2 of the reports and sending them. It doesn't error out, it just ignores the last 30 or so of the 60 reports I'm creating, even popping up the "I'm complete" message when finished. No error, no debugging, just ignoring part of the variable srange.
The code works (creates all 60 of the reports) IF i activate the counter lines and press OK in between each report, but that almost defeats the purpose of the macro.
Any ideas?
Bookmarks