call with =numbersheets()

Function numbersheets()

numbersheets = Worksheets.Count
End Function

I would recommend the info function but instead of returning 3 worksheets,
it is returning 6. I not going to tell you to use something that gives a
wrong answer.
=INFO("numfile")




"Dawn" wrote:

Is there a way to write a function that will return the worksheet count to
the user on demand? I know worksheets.count will return the number in VBA -
but how do I make it a function to show the number when needed by the user?