I'm trying to delete sheets 1,2,4,5 and make sheet 3 the active one. I get the error on " Sheets(1).Selec t" and "Sheets(Array(1 , 2, 4, 5)).Select". I get a run time error when I try and run the following macro. Help?
zFolder = zPath & "\Kitty*"
Application.Dis playAlerts = False
Sheets(1).Selec t
ActiveWindow.Sc rollWorkbookTab s Position:=xlFir st
...
User Profile
Collapse
-
grippy10 started a topic Getting Run-time error '9': when trying to open workbook and delete all sheets but 1in Visual BasicGetting Run-time error '9': when trying to open workbook and delete all sheets but 1
No activity results to display
Show More