Count number of sheets
 

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

Count number of sheets
 

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?

Count number of sheets
 

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?

Count number of sheets
 

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?

Count number of sheets
 

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?

Count number of sheets
 

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?