It would be useful for you to describe what processing you are doing to the
worksheets.

--

Vasant

wrote in message
...
I understand what your are sayinb by grouping and
ungrouping. But How can i implement this by vba???

Any help would be appreciated
-----Original Message-----
Are you familiar with Worksheet grouping and its benefits?
Hold down the shift-key and clink First and Last sheet
for contiguous or
Hold down the Control-key and click individual sheets to
be "grouped"...
HTH

wrote in message
...


I want to perform similar operation in 5-6 sheets of a
workbook. I am currently following the proces as :

For i = 1 To ActiveWorkbook.Worksheets.Count
processEachWorksheet
If exitFlag = True Then Exit Sub
Next i

ie. I am doing a similar process 5-6 times. Can it be
possible that I i do the processing for each sheet at
the
same time? Is something like this possible:
For each sheet...
'do this

If possible will it make any difference in the total
time
taken?

Thanks


.