Macro to take me back to the page i was just on?

[tonywatsonhelp]

Hi Everyone,

I guess what i need will be two macro,

the first to take me to a page, t

the second to take me back to where I was.

This is how I think it could work.


Macro1
I click macro 1 it takes me to Sheet "Info"
and records the name of the sheet I was on in Sheet "Control" cell D1

Macro2 when selected takes me to sheet "Whatever name is in control D1.

please help if you can

Tony

 

[JackDanIce]

Try:

Sub Macro1()
Sheets("Control").Cells(1,4).Value = ActiveSheet.Name
Sheets("Info").Select
End Sub

Sub Macro2()
With Sheets("Control")
  If Len(.Cells(1,4).Value) Then Sheets(.Cells(1,4).Value).Select
End With
End Sub

 

[tonywatsonhelp]

Brilliant, Thanks very much Jack dan.

 

[JackDanIce]

You're welcome