Try this udf:

Function sheetcount() As Long
sheetcount = Sheets.Count
End Function

--
Gary''s Student - gsnu200845


"Dale" wrote:

Hi, is there a way I could display how many sheets I have in a workbook

Thanks