Why is subscript out of range?
Hi, I just want to copy an entire row (a2) to another sheet (also row (A2), and I have tried using this code:
Rows(6).EntireRow.Copy
Sheets(“NMBW”).Range(“A2”).Select
Sheets("NMBW").Paste
... but it warns that "Sheets(“NMBW”).Range(“A2”).Select" is "subscript out of range"..
I really don't understand, everything seems to be in order?
check the typo of sheet NMBW
The error means the sheet you are trying to access does not exist on sheet collections.
But it does exist :/ ... with the exact letters and everything. I am really confused.
Do you have many workbooks opened? The code assumes it is the active workbook.
Hi,
You have the wrong kind of quotation marks in that second line. It needs to use straight quotation marks as the subsequent line does:
rather than:
Please Login or Register to view this content.
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
Ok, I've changed the quotations, now I get a new error that says on the same line 2:
"select method of range class failed"
code is:
Rows(6).EntireRow.Copy
Sheets("NMBW").Range("A2").Select
Sheets("NMBW").Paste
In order to select a range on a sheet, you must activate that sheet first. However selecting is unnecessary in this case as you can specify the destination for the copied range thus:
Please Login or Register to view this content.
this worked perfectly thank you!
You don't even need copy. Just change the 100 in the number of columns you want to copy.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
However your approach assumes that only values are required, of course.Originally Posted by bakerman2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks