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