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