This user defined function will do it...

Public Function WksCount() As Integer
WksCount = Application.Worksheets.Count
End Function

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Bill from Holland Michigan" wrote:

I want to show how many sheets I have in a workbook using a formula. The
number changes everyday. What do I use, or can I even do this?