View Single Post
  #1   Report Post  
Dr.Schwartz
 
Posts: n/a
Default Selecting sheets

How can make my code add a sheet to a selection?

Something like:

Dim WSName As Worksheet
For Each WSName In Worksheets
If Left(WSName.Name, 3) = "Pre" Then
'the code for adding the sheet to the selection
End If
Next

Thanks
The Doctor