need a macro to go to an exist plan according the value of a cell

[Eduardo Rudge Taylor]

Imagine a cell A1, with value = 1 (number format). Execute a macro to go to a plan called "1" (same value of cell A1 of the original plan).
I have few cells, from A1 to A25, and 1 plan called "original" and plans with the same name of cell range (from 1 to 25).
Once I go to A20, the value within is 20, for example, I need to execute the macro and jump to plan called 20.

I hope that I was clear.
Thank you.

 

[Hui]

Eduardo

Firstly, Welcome to the Chandoo.org Forums

Can you please upload a sample file which indicates your requirements

 

[Krishna Kinker Singh]

Hi,
Please attach a sample excel file showing what you actually want,

Thanks

 

[Eduardo Rudge Taylor]

Hi Hui, the sample file that you request.
Thanks

Eduardo

Firstly, Welcome to the Chandoo.org Forums

Can you please upload a sample file which indicates your requirements

 

[Eduardo Rudge Taylor]

Hi,
Please attach a sample excel file showing what you actually want,

Thanks

 

[Harpreet Singh]

you can use Worksheet_BeforeDoubleClick Event for this Macro. Whenever you double click on Plan, you will go to the same Plan. Please take a look on sample file.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

Dim i As String
On Error Resume Next

i = ActiveCell.Value
Sheets(i).Activate

On Error GoTo 0


End Sub