ExcelBanter - Check Activesheet for chart sheet or work sheet

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Check Activesheet for chart sheet or work sheet (https://www.excelbanter.com/charts-charting-excel/150565-check-activesheet-chart-sheet-work-sheet.html)

NSK

Check Activesheet for chart sheet or work sheet

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

Thanks

Andy Pope

Check Activesheet for chart sheet or work sheet

Hi,

You could use the Typename funciton.

MsgBox TypeName(ActiveSheet)

Cheers
Andy

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

Thanks

All times are GMT +1. The time now is 05:34 PM.