.select method with worksheets object ex. Sheets("Sheet1").range.select fail

Hello,

I am having a problem with this though it is not so much getting done what I want to get done (there are a million ways to do this) but more of something that is blocking my understanding of a bigger concept.

Please Login or Register  to view this content.

Why is this? Can someone point me to a good article that explains this. Sorry if this is too basic.

try this one:

Sub test01()

Set test = Worksheets("Sheet1")
With test
.Range("A10").Select
End With

End Sub

I think it's because that worksheet is not the active worksheet.

Try this. Before test.range("A1").select, activate the worksheet by doing test.activate

There is nothing wrong with your code unless you have option explicit as declaration.

Please Login or Register  to view this content.

Zekaroui: I am using that workaround though I am just confused about the reason why this is failing in the first place.

AB333: I get the error "Select methos of range class failed" with this code with and without option explicit.

This works though,

Please Login or Register  to view this content.

Thank you all for your replies and attention. Much much appreciated. Sorry if this is VBA 101...

I just don't understand why the initial code doesn't work...

Well, this one works for me too.

Please Login or Register  to view this content.

Is it because I am calling this as a subroutine from a btn_click action. I have the sub in a module and the button click action is called from the sheet code (sorry I don't know exactly what it is called.)

It may/may not. Could you please post both codes?

Norie,
There is no active or passive worksheet. I do not see any error on my code.
It is obviously is the active workbook.

Sorry about the delayed response. I am calling the sub routine from a button on another sheet so Sheet1 is not active when I am trying to select the cell.