You could use this function. Al + F11 to open VB editor, right click this
workbook and insert module and paste this in.

Function sheetsinbook()
sheetsinbook = Worksheets.Count
End Function

this formula in a cell will return the number of worksheets.
=sheetsinbook()

Mike



"alm09" wrote:

Is there a way to count the number of tabs in a worksheet?