Try

Sub stantial()
numsheets = Worksheets.Count
end sub

Mike

"tc" wrote:

Hi. I want to create a macro that will count the number of sheets in a
particular workbook. Is this possible?