Maybe you can just search for more of the name:

If InStr(1, .Name, "OT (", vbTextCompare) Then




KimberlyC wrote:

Hi..
Below is part of some code I'm running..
This part:
InStr(1, .Name, "OT", vbTextCompare)
Call PrintareaOT2
is running when the "Other Deductions" workheet is active.. so I am asumming
it's picking up the OT in the Other Deductions name.
Is there a way to have this code check the sheet's name.
The reason for not identifying the exact names of the sheets is because
there can be multiple sheets with the same name ...they just have numbers
after them....
like Other Deductions (2).. and so on ... and OT (2) and so on...

***********************
With ActiveSheet
If InStr(1, .Name, "OT", vbTextCompare) Then
Call PrintareaOT2
End If
If InStr(1, .Name, "Other Deductions", vbTextCompare) Then
Call PrintareaDeductions2
End If

End With

As Always.. thanks in advance!!
Kimberly

--

Dave Peterson