Macro code

[colinharwood]

Hi All

Is it possible to write macro code which will return to the original sheet where the macro was started from, no matter which sheet you start the macro from?

Cheers

Colin

 

[Mark O'Brien]

Yes.

Simply declare another variable and set it to the current sheet before doing anything. Then after your code has run, make that sheet the active sheet again.

e.g.

<pre>
Dim shtMySheet As Worksheet

Set shtMySheet = ActiveSheet

'...
'Your code here e.g.
Sheets("Sheet2").Activate
'...

shtMySheet.Activate</pre>