Check Activesheet for chart sheet or work sheet

[Guest]

Is there any method that will check whether the active sheet is a chart sheet
or a worksheet?

Thanks

 

[Andy Pope]

Hi,

You could use the Typename funciton.

MsgBox TypeName(ActiveSheet)

Cheers
Andy