Return to the Active Worksheet at time macro is run

[alyssa75]

How can I tell my macro to come back to the worksheet the macro is run from....using ActiveWorksheet or something like that? I don't want to tell it specifically by name since the macro can be run from different sheets.

Thanks!

 

[xenou]

You just want to tag your worksheet when the macro starts:

Sub Macro1()
Dim ws As Worksheet

    Set ws = ActiveSheet
    
[COLOR="SeaGreen"]    '//Do Code
    '//Do Code[/COLOR]
    
    ws.Activate

End Sub

ξ

 

[Norie]

You shouldn't need to unless the code activates or selects another worksheet and you almost never need to do that.