Is there a way to count all the worksheet tabs in an Excel speadsheet...like a macro?
P PCGArts Apr 14, 2006 #1 Is there a way to count all the worksheet tabs in an Excel speadsheet...like a macro?
B Bob Phillips Apr 14, 2006 #2 Activeworkbook.Sheets.Count -- HTH Bob Phillips (remove nothere from email address if mailing direct)
Activeworkbook.Sheets.Count -- HTH Bob Phillips (remove nothere from email address if mailing direct)
