As with most people, I'm new to VBA and I'm looking for some guidance.
I created a master template which will generate and then save a version for each department I oversee. To do this, I embed a macro which will:
1. Pull information from an Essbase Retrieve tab
2. Populate that information in a Summary tab
3. Hide zero sum rows on Summary Tab
3. Save the information as it's own filename
4. Unhide all rows, then move on to the next BU listed on a BU List tab and repeat
For some reason, I keep running into an error at the end of the script: Run-time error '1004'. I've been trying to remove .Select from my code, which is reflected below, but maybe I didn't do this properly? I've inserted a scrubbed version of my BU list to give context to my code.
One final issue is the last line of code - application.statusbar. For some reason it stops at 86% and will not update the status beyond that. I also attached a screen shot of my 'BU List tab.' Any advice is appreciated!
Bookmarks