Run time error - Subscript out of range - VB in Excel

M

myrka

Hi All

Sub makro()

Dim zm As String

zm = Worksheets("Store").Range("N1")

End Sub


******************************
Run time error - Subscript out of range
******************************
In the Worksbook are 11 sheets - If it has meaning
May be some any of the excel expert here can help to explain...
Any help is appreciated.

Windows XP Professional
Excel 2002 SP3


Marcin Karlewski
 
H

Helmut Weber

Hi Myrka,

apart from other issues,

are you sure that there is a worksheet named "Store"?

HW
 
D

Dave Peterson

The active workbook doesn't have a worksheet named "Store".

You may have extra spaces (leading or trailing) in the worksheet name--or you
may have the wrong workbook active.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subscript out of range 1
ERROR: subscript out of range 6
Runtime Error '9': Subscript Out Of Range 6
Error Message - Macro to Unlink MS Queries from Workbook 0
Subscript out of range 26
Access Subscript out of range when importing into access 2010 from excel 0
subscript out of range 2
Subscript out of range error 7

Top