activesheet: chart or worksheet?

M

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
 
B

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)
 
Top