how to get sheet's number it's name

A

alekm

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
 
K

kassie

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

Bob Phillips

MsgBox Worksheets("G1").Index

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Top