I have a worksheet that I need to perform some copy and paste operations on when it's opened, which I do with a macro in PERSONAL.XLSB. It's a really long and messy macro, but the critical part of it is this, as far as I can tell:
Which is for some reason pasting into PERSONAL.XLSB. I tried getting rid of the "Sheet1" in PERSONAL.XLSB but that just caused an error. Is there a better way of pointing Excel at the spreadsheet I want?Please Login or Register to view this content.
Bookmarks