I've created a macro button that I'd like to be located in the first row.
The problem I'm running into is, if I try to Copy & Paste my data from another workbook into any cell other than A1, the following error message appears:
To Copy all cells from another worksheet to this worksheet make sure you paste them into the first cell A1 or R1C1
Is there a work around for this?
I know that I could add a macro button into the Toolbar, but I'd rather not, if possible.
The problem I'm running into is, if I try to Copy & Paste my data from another workbook into any cell other than A1, the following error message appears:
To Copy all cells from another worksheet to this worksheet make sure you paste them into the first cell A1 or R1C1
Is there a work around for this?
I know that I could add a macro button into the Toolbar, but I'd rather not, if possible.