-
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.
-
this will read all you tab sheet...
code:=======================================
Dim strSheet As Worksheet
For Each strSheet In Worksheets
MsgBox strSheet.Name
Next
-
Thanks Knight.
Excellent.