Simple problem

[Khazimula]

Hi all,

I know this is probably really simple, but its got me pretty stumped. I'm trying to use VB to look through a workbook and select all sheets starting with HA, one at a time. I know in excel, HA* can be used. Does anyone know whether there is something similar in VB?

 

[Norie]

Can you post what code you have?

Dim ws As Worksheet

For Each ws In ActiveWorkbook.Worksheets

    If Left(ws.Name)="HA" Then
       Msgbox ws.Name
    End If

Next ws

By the way you've posted in the Access forum.