VBA - Is this SheetX a worksheet or chartsheet

[liveinhope]

Just learning VBA . I know about the sheets collection and worksheets collection

and I know activesheet. But how do you determine if a given sheet (eg it activesheet, sheets(1) , or sheets("thissheet") ) is a worksheet or a chartsheet.

So you dont do and do something that will crash like sheets(1).range("A1") = 23 on a chartsheet

 

[JoeMo]

Try this on a workbook that has both a chart sheet and a worksheet.

Sub GetSheetType()
For Each Sh In ActiveWorkbook.Sheets
MsgBox TypeName(Sh)
Next Sh
End Sub

 

[Michael M]

If you Dim your sh as object, it will look at ALL sheets
If you Dim your sh as worksheet, it will only look at worksheets

A couple of simple examples here

Daily Dose of Excel » Blog Archive » Looping Through Sheets

 

[liveinhope]

thanks to you both - I'm getting a bit further !