VBA: Error 1004: Select Method of Range class failed

[--ndn.diva--]

I'm writing a macro to retrieve data from an Excel add-in. It's only a few lines of code, and I've written it several times and it has worked perfectly. However, this time, I get an error message: Select Method of Range class failed.
The section of code that is causing the problem is:
If (Range("Month") = "9") Then
Sheets("Analysis May 08 NLD").Activate
Range("A2:B51").Select 'code that is causing the problem
Application.Run ("EssmenuRetrieve")
Sheets("Analysis May 08 LDD").Activate
Range("A2:B51").Select
Application.Run ("EssmenuRetrieve")
MsgBox ("Data Retrieved")

The value in the cell "Month" is 9, so that part of the code is working properly. I've tried changing the value in that cell to another number, and running the code, after changing the sheet name to the corresponding month, however, I got an error at the same point.
I've made sure that everything is typed in correctly (as i said, i've written this bit of code before).

Any suggestions?
Thanks!!

 

[Norie]

You might have typed everything in correctly, but are you sure you are referencing everything correctly?

Without a worksheet reference here VBA will be looking at the range on what it regards as the active sheet.

Range("A2:B51").Select

 

[--ndn.diva--]

What do you mean by "worksheet reference"?
The macro is reaching the correct worksheet. (I checked this by having excel display a message box after each line of code)

 

[Norie]

What I mean is exactly what I said.

Without a worksheet reference here VBA will be looking at the range on what it regards as the active sheet.

This will explicitly reference the range on the Analysis... sheet.

Sheets("Analysis May 08 NLD").Range("A2:B51").Select 

Though I'm not sure what you are actually trying to do and/or whether the problem is with the code you've posted.

It's not normally needed to use select and you are calling other subs, where the problem might actually be.

 

[--ndn.diva--]

That code worked. thanks!!