ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there a way to count all the worksheet tabs in an Excel speadsh (https://www.excelbanter.com/excel-discussion-misc-queries/83271-there-way-count-all-worksheet-tabs-excel-speadsh.html)

PCGArts

Is there a way to count all the worksheet tabs in an Excel speadsh
 
Is there a way to count all the worksheet tabs in an Excel speadsheet...like
a macro?

Bob Phillips

Is there a way to count all the worksheet tabs in an Excel speadsh
 
Activeworkbook.Sheets.Count

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"PCGArts" wrote in message
...
Is there a way to count all the worksheet tabs in an Excel

speadsheet...like
a macro?




Dave Peterson

Is there a way to count all the worksheet tabs in an Excel speadsh
 
And just in case...

Activeworkbook.Worksheets.Count

PCGArts wrote:

Is there a way to count all the worksheet tabs in an Excel speadsheet...like
a macro?


--

Dave Peterson


All times are GMT +1. The time now is 04:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com