Solved: Find a sheet name

[ron]

Hey,

I need assistance with writing the code to place the sheet name in a variable that is directly to the right of a sheet named Index.

Thanks

ron

[Bob Phillips]

You can't have a sheet named Index, Excel rejects it.

[Bob Phillips]

Sorry, that was juts my Excel playing up.

Try this

[vba]

myVar = worksheets(worksheets("Index").index+1).name
[/vba]

[Bob Phillips]

Bit of error checking might help

[vba]

If Worksheets("Index").Index < Worksheets.Count Then

myVar = Worksheets(Worksheets("Index").Index + 1).Name
Else

MsgBox "Oops!"
End If
[/vba]

[ron]

xld,

It works perfect, thanks

ron