how to get sheet's number it's name

[Guest]

Hi,
is it possible to get sheet's order number if it's name is known (eg.
Sheets("G1") what number is it?)?
thanx

alek_mil

 

[Guest]

Whilst in Excel, press <Alt><F11> to go to VB. In the left hand window, you
will see a list of the sheet names, with their numbers, eg Orders(Sheet1);
Stock(Sheet2) and Invoice(Sheet3)

 

[Bob Phillips]

MsgBox Worksheets("G1").Index

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)