activesheet: chart or worksheet?

[mfp]

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

 

[Bob Phillips]

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]

It worked out beautifully - thanks a lot