Hello- the below code from my macro is not pasting in cell A1 on the sheet I want it to, but instead is pasting into a random place on the sheet. Can I add something here in order for the results at the end of my macro to paste in A1?
*It selects data from another workbook and then opens template.xlsm. Here is where I want it to paste into cell A1. (the code used to have Range("D13").Select, but I changed that in an attempt to solve this issue.
Windows("template.xlsm").Activate
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A1").Select
Thank you!
*It selects data from another workbook and then opens template.xlsm. Here is where I want it to paste into cell A1. (the code used to have Range("D13").Select, but I changed that in an attempt to solve this issue.
Windows("template.xlsm").Activate
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("A1").Select
Thank you!