Try,

Typename( activesheet)

it will return Chart or Worksheet

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"mfp " wrote in message
...
How do I tell whether the activesheet is a chart or a worksheet. I don't
want crappy code (i.e. on error....). It would be smooth if there was a
sheet property that would let you know what kind of sheet you were
dealing with (chart or worksheet) - does such a thing exist? Cheers,
Mike


---
Message posted from http://www.ExcelForum.com/