Freddie Mac wrote:
Is there a way of counting worksheets that have the
same name beginning (i.e. counting all worksheets that have name starting
with Report) or is there any other way of solving the problem? Please help me!


Hi Freddie

You could use a For... Next Loop and include

If Left(sh.Name,6) = "Report" Then
shtcount = shtcount + 1

Report shtcount at the end of your routine

Regards

Steve