Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart formula style depends on number of sheets.... | Charts and Charting in Excel | |||
How to print a selected number of sheets? | Excel Worksheet Functions | |||
Count the number of sheets. | Excel Discussion (Misc queries) | |||
Name and number of sheets | Excel Discussion (Misc queries) | |||
Automatically number multiple sheets | Excel Discussion (Misc queries) |