VBA Code for 2nd Previously Active Sheet

[Dataframe]

Hi everyone. Is there VBA code to take you to the 2nd Previously Active Sheet ?

I have Sheets 1 to 12, a Raw Data sheet, and a Transfer sheet. From one of the sheets 1-12 (continually varying) I run a macro that processes and moves selected data from the Raw Data sheet to the Transfer sheet.

After that is done, I need to return to whichever of the Sheets 1 to 12 that I originally came from.

So, to recap ...
1. Start in one of the sheets 1-12. Running a Macro there takes me to ...
2. Raw Data sheet. The Macro processes data and transfers it to ...
3. Transfer sheet. I then wish to return to whichever sheet I started in.

Can this be done ?

 

[Alex Blakenburg]

Yes, whichever of the sheets 1-12 the Macro 1 is run from, it goes back to that initial sheet.

The Public Statement is in ThisWorkbook module.

The public statement needs to be at top of a standard module under the Modules Node

 

[Dataframe]

The public statement needs to be at top of a standard module under the Modules Node

Oh, okay. I’ll try that and let you know.

 

[Dataframe]

The public statement needs to be at top of a standard module under the Modules Node

Hey Alex, it worked. Thanks very much, I appreciate you and Akuini's help with this.

Akuini ... FYI ... It looks like the reason your suggested solution wasn't working for me originally is because I had the text "Public sName As String" in the ThisWorkbbok module instead of a standard module. Alex followed on from your suggestion and helped me get there. So thanks to both of you.

 

[Alex Blakenburg]

Thank you for letting us know. Glad we could help.