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.