Hi There, I am new to VBA and am looking for some pointers to make my code more efficient.
I have a workbook containing 12 sheets to be fed data from a pivot table in another workbook. right now it is running only one and taking a long time...6 seconds. I fear that once all 12 sheets are populating their respective data the macro will run for 72 seconds.
Can anyone spot beginner mistakes with my code. Again I would like to emphasize I am not looking for someone to clean it up or re-post my code using 10 lines, I am more looking for areas to "re-learn", possibly some alternatives to .Select, and .Activate? Am i on the right path with this code?
ps. I left out the web address and file paths for obvious reasons...
Thanks in advance!
Please Login or Register to view this content.
Bookmarks