how to get sheet's number it's name
 

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

how to get sheet's number it's name
 

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)
--
Hth

Kassie Kasselman


"alekm" wrote:

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

how to get sheet's number it's name
 

MsgBox Worksheets("G1").Index

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"alekm" wrote in message
...
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