Thread: Check Activesheet for chart sheet or work sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default 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
Reply With QuoteReply With Quote