Hi paritoshmehta ,

It's hard to say without seeing the code. But most likely, the active
worksheet is not the one on which you're trying to select cells. That will
cause a runtime error.

To solve it, you have a few options:

1) Don't select cells. Most (almost all) actions can be performed without
changing the current selection. For example, instead of doing this:

Sheets("Sheet1").Select
Range("A1").Select
MsgBox ActiveCell.Value

you could do this:

MsgBox Sheets("Sheet1").Range("A1").Value

Besides being faster, the second method doesn't change the user's active
selection.

2) If you must select cells, try the GoTo method instead:

Application.GoTo Sheets("Sheet1").Range("C1:D10")

This will not fail if the active worksheet is not Sheet1.


It's also possible that you would get this error if you are running code
from a CommandButton placed on a worksheet - if that's the case, try setting
the TakeFocusOnClick property of the button to False.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Hi

I am getting this error 1004 "select method of range class failed"
when my macro tries selecting some cells in a sheet,

can someonw help about the possible causes!!!


---
Message posted from http://www.ExcelForum.com/