Getting Subscript out of range error when copying text from Sheet1 to Sheet9

Asked Aug 24 '22 at 18:31

Active Aug 24 '22 at 18:31

Viewed 30 times

Trying to copy something from Sheet1 to Sheet 9 but keep getting subscript out of range error. Created a dummy excel just to test out the code and it works there but doesn't work in my main one. Please help.

Sub Copy()
Sheets("Sheet1").Range("B5").Copy Destination:=Sheets("Sheet9").Range("K1")
End Sub

Error message and VBA window

asked Aug 24 '22 at 18:31

DM24

Try `worksheets()`? – findwindow Aug 24 '22 at 18:32
2

Most likely is that there is not a worksheet called `Sheet1` or `Sheet9`. When using `Sheets()` or `Worksheets()` you are looking at the editable sheet name show on the tab and not the code name. – Scott Craner Aug 24 '22 at 18:33
4

`Sheet1` is "Synthesis" in your workbook, same situation probably for `Sheet9` – Warcupine Aug 24 '22 at 18:34
Try using the worksheets' code names: `Sheet1.Range("B5").Copy Destination:=Sheet9.Range("K1")`. – VBasic2008 Aug 24 '22 at 19:02

Getting Subscript out of range error when copying text from Sheet1 to Sheet9

0 Answers0