Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Mike:
Sorry, forgot to put that into my question. Scope is workbook.
Runtime error 1004 - select method or range class failed
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I have an Excel workbook with 3 sheets, Orders, Plan, Budget. On the plan sheet, I have a named range called lastytd. I have verified that the range definition in the name manager is correct and points to the correct range on the plan sheet. When I reach the following line of code in my moldule1, I get Runtime error 1004 - select method or range class failed
Worksheets("plan").Range("lastytd").Select
What am I doing wrong?
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
2 answers
Sort by: Most helpful
-
Anonymous
2013-06-20T18:45:06+00:00 -
Anonymous
2013-06-20T17:56:40+00:00 Hi,
What is the scope of the named range? If the scope of the range isn't 'Workbook' then if you try to select it and the sheet 'Plan' isn't the active sheet then that line will fail.
Check the scope in the Name manager.
This should work with the usual caveat that it's very unlikely you need to select a range to do something with it.
Worksheets("plan").Select
Range("lastytd").Select