Excel and Errors

[graham.flynn]

I can open an Excel file no problem.
I can activate a specific tab in the Excel file no problem.

I want to check for the tabs existence before I try to activate it to prevent an error occuring.

Does any body know the correct syntax?

The following works (unless the tab called 'Test Tab' does not exist);

Worksheets("Test Tab").Activate

Thanks

Graham.

[VBKNIGHT]

this will read all you tab sheet...
code:=======================================

Dim strSheet As Worksheet
For Each strSheet In Worksheets
MsgBox strSheet.Name
Next

[graham.flynn]

Thanks Knight.

Excellent.