Thread: return text not index for property
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sibilia[_4_] Sibilia[_4_] is offline
external usenet poster
  
Posts: 1
Default return text not index for property

Try

MsgBox ActiveSheet.Name

Sibilia


Nicky Wrote:
Hi all
A simple question, I hope
how do I return the name rather than the index number for a property,
so that eg

MsgBox ActiveWorkbook.FileFormat

returns "xlWKS" not "39"


--
Sibilia
------------------------------------------------------------------------
Sibilia's Profile: http://www.excelforum.com/member.php...o&userid=21363
View this thread: http://www.excelforum.com/showthread...hreadid=380800

Reply With QuoteReply With Quote