Do you mean this Mike

Sub test()
If ActiveSheet.Name = "Sheet1" Then
MsgBox "Sheet1 is the ActiveSheet"
Else
MsgBox "Sheet1 is not the ActiveSheet"
End If
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"mike allen" wrote in message ...
i would like to see if a specific worksheet is in a workbook. something
like:

If issheet("sheetX") Then
'look up stuff on 'sheetX'
Else
'don't look up stuff on 'sheetX'
End If

i realize "issheet" is wrong, but what would be correct? thanks, mike allen