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

  • Thread starter Thread starter myrka
  • Start date Start date
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
 
Hi Myrka,

apart from other issues,

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

HW
 
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

Back
Top