return text not index for property

Try

MsgBox ActiveSheet.Name

Sibilia

Originally Posted by Nicky

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"