Runtime Error 1004 "Active method of range class failed".

Hi fellow excellers,

Set up a command button that calls a sub routine.

Getting a runtime error 1004 "Active method of range class failed".

Error traced back to the following line of code:
Worksheets(WORKSHEET_NAME).Range("E5").Activate

What am i doing wrong?

Thanks.

Hi tom1977,

I've defined WORKSHEET_NAME as a constant, is this still okay?

Public Const WORKSHEET_NAME = "REPORT LOOK UP (2)"

Thanks.

hi new2excel2012, you will get that error for:

Please Login or Register  to view this content.

every time when the referenced sheet is not the active one.

To avoid that error you can do this:

Please Login or Register  to view this content.