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

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

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/

It worked out beautifully - thanks a lot

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