number of the sheet 2

[kenguru]

Hello,

How can i return the number of the sheet ABC?
I tryed:
drb=Sheet("ABC").Names.Count
but it didn't work.

Thank you,
Kenguru

 

[PHV]

A starting point:
For drb = 1 To Sheets.Count
If Sheets(drb).Name = "ABC" Then Exit For
Next

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[AnotherHiggins]

drb= ActiveSheet.Index
[tab]or
drb= Sheets("abc").Index

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[kenguru]

Thanks, it works

 

[AnotherHiggins]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.