Tab Formual

[jasonb147]

Hi All

Is there a way (via formula) to navigate direct to a selected tab?

Basically I have a spreadsheet with around 100 tabs all for individual service contracts. What I want to do is to be able to enter the name of a tab into a call and it takes me to that tab. Is this possible?

Thank You

 

[SkipVought]

Hi,

enter the name of a tab into a call

What does that mean?

Why not right-click the workbook navigation buttons in the lower left and select the sheet?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[jasonb147]

I meant Cell!

 

[SkipVought]

And my other question????

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

BTW, you could use the HYPERLINK() function. Check it out in HELP.

However, if you want something more automatic, you will need to have an event-driven VBA procedure (macro). Post in forum707 for help with VBA.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]