Check Activesheet for chart sheet or work sheet

N

NSK

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

Thanks
 
A

Andy Pope

Hi,

You could use the Typename funciton.

MsgBox TypeName(ActiveSheet)

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Copying embedded charts 1
Creating a check sheet - to include paragrpahs or remove paragraphs 1
Charting macro for creating multiple charts on multiple sheets 0
One extra x axis item that wont go away - can anyone help? 3
Charts in Multiple Sheet in Excel 1
Bar Chart with Data Elements 1
VBA for Dependents shortcut menu 0

Top