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:
wb.worksheets("sheet2").select
Range("A" & somevariable).select
Selection.copy
wb.worksheets ("sheet1").select
Range("A" & anothervariable).select
Activesheet.paste
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?
Bookmarks