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

[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

 

[Helmut Weber]

Hi Myrka,

apart from other issues,

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

HW

 

[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.