Bob,

Don't think that'll work unless you Dim "active" as a workbook. A typo,
mayhaps?

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Bob Phillips" wrote in message
...
Active.Worksheets.Count

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Terry" wrote in message
...
How do you count how many Worksheets (tabs) in a Excel
file. I know at one time I have a macro that went through
each worksheet.
I'm trying to get the number of worksheets
and then loop thru all the worksheets and if the tab name
of any start with "R-" copy the data from that worksheet
to another to combine all the data from all the "R-"
worksheets.

If this makes since can anyone help me? Thanks