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

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?

Use this UDF:

Function sheetcount() As Integer
sheetcount = Worksheets.Count
End Function

--
Gary''s Student - gsnu200743


"tc" wrote:

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

Please don't post the same message in multiple newsgroups. It only tends
to fragment your answers, and potentially waste the time of those
answering questions that have already been answered...

In article . com,
tc wrote:

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

Note that this will give you the number of sheet in the ACTIVE workbook,
not in "a particular" workbook...

In article ,
Gary''s Student wrote:

Use this UDF:

Function sheetcount() As Integer
sheetcount = Worksheets.Count
End Function

--
Gary''s Student - gsnu200743


"tc" wrote:

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

Worksheets would be a subset of the sheets in a workbook.

if there could be chart sheets or macro sheets (less likely) as well

activeworkbook.Sheets.count

--
Regards,
Tom Ogilvy


"tc" wrote:

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