Processing all worksheets simultaneously
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
|