I am trying to cut a varying number of rows, user entered index n, and paste these data into the j'th column of a new sheet.
Here are the relevant commands I have trying to do so; NOTE: "NAME" is just so I didn't have to type out the workbook name, I'm posting this on a separate computer not running the Macro
The error appears in the second line of what is shown above. Thanks in advance for your help.
Here are the relevant commands I have trying to do so; NOTE: "NAME" is just so I didn't have to type out the workbook name, I'm posting this on a separate computer not running the Macro
Code:
Workbooks("NAME").Sheets(6).Range("A1:E" & n).Cut
Workbooks("NAME").Sheets(7).Cells(1, j).Paste
The error appears in the second line of what is shown above. Thanks in advance for your help.