In vba you can get the count with

ACtiveworkbook.Sheets.Count

So I think you would need to incorporate that in a UDF.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Olle Svensson" wrote in message
...
Hi.

I want to do the simplest thing possible; count the number of sheets in a
workbook and show the result in a cell.

See, basically, I want every new copied sheet to have a reference in a
cell
like this:
=(numberofsheets)-1

I know about the footer and header but I have sheets that are for summary
and index reasons which would throw off the count of the sheets I intend
to
copy.

Not sure if this makes any sense, I pretty much just want to count the
number of sheets with a formula.

Thank you,
Olle Svensson