« Create a time delay (pause): VBA Excel | Main | Select first empty cell: VBA Excel »
Sunday
Jul152007

Select certain sheets in workbook: VBA Excel

DateSunday, July 15, 2007 at 11:42AM

Sub SelectSheets()
    For Each sht In Sheets
        If TypeName(sht) = "Chart" Then sht.Select False
    Next sht
End Sub

AuthorGleb | CommentPost a Comment |

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
All HTML will be escaped. Textile formatting is allowed.

Notify me of follow-up comments via email.