Error with recorded macro

[artz]

Hi,

I recorded the following macro with the macro recorder:

Sub Change_Worksheet()
    Sheets("Portfolio").Select
    Range("B2").Select
End Sub

It simply switches worksheets and and activates a cell. When I cal this sub from within another sub, I get the message: ' Select Method of Range Class failed'

Can Anyone in the Forum have a suggestion to modify the sub so that this error does not occur?

Thanks,

Art

 

[Dryver14]

try

Sub Change_Worksheet()
    Sheets("Portfolio").Range("B2").Select
End Sub

 

[artz]

Thanks for your response, however, I get the same error message as with my sub when your sub is called.

Any other suggestions?

-Art

 

[Domenic]

Hi,

I recorded the following macro with the macro recorder:

Sub Change_Worksheet()
    Sheets("Portfolio").Select
    Range("B2").Select
End Sub

It simply switches worksheets and and activates a cell. When I cal this sub from within another sub, I get the message: ' Select Method of Range Class failed'

Can Anyone in the Forum have a suggestion to modify the sub so that this error does not occur?

Thanks,

Art

Seems to work fine for me...

 

[artz]

Domenic,

Thanks for your comments. I am curious as to why it works for you and I get an error when the sub is called.

Any thoughts?

Art

 

[Dryver14]

just tried this

Sub callit()
Call Change_Worksheet
End Sub

and it works, do you have the underscore in the call?

 

[artz]

I was able to activate the new worksheet using:

    With Sheets("Portfolio")
    .Activate
    End With

-Art