How can I count number of sheets present in a workbook?

B

Bob Phillips

in the immediate window in the VBIDE

?Activeworkbook.Sheets.Count

if you just want the worksheets


?Activeworkbook.Worksheets.Count

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I find the Worksheet Menu bar in Excel if that is missing? 3
V lookup in separate TABS! 1
CountIF 11
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
HOW DO I SET UP A SMALL BUSINESS USING EXCEL? 1
Remove Numeric from a Text String - Help? 9
how to show the date a spreadsheet was modified in a cell 0
How do I count cells with a specific cell shading? 3

Top