Thread: how to get sheet's number it's name
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 1,726
Default 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 With QuoteReply With Quote