Hi,

Alt +F11 to open VB editor. Right click 'This Workbook' and insert module
and paste the code below in. Call with

=numsheets()

Function numsheets()
numsheets = Worksheets.Count
End Function

Mike

"JonWardellBuilders" wrote:

I need to know a function that i can enter into a cell that will give me the
total number of worksheets i have in a specific Workbook.

it will serve as an invoice number because i create a new sheet for each
invoice i have.

thank you.
--
Jon Robershaw
Wardell Builders, Inc