number of worksheets

F

Frank Kabel

Hi
AFAIK you'll need a UDF for this. e.g. try something like the following
Public Function count_sheets() As Integer
Application.Volatile
count_sheets = Sheets.Count
End Function

and enter =count_sheets() in one of your cells
 

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

VBA Coding Help for Beginner 0
Syncing between source worksheet and dependent worksheets 0
Can't delete sheets 8
VBA to do a mailmerge from a Specific Excel worksheet 0
Renaming wrong worksheet. Why? 3
Editing an "IF" function across a worksheet/excel file 2
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0

Top