Hi Ian,
Thanks for you reply.
The Worksheet.Calculate can be used to trigger recalculation in a sheet
at a time. Using it for all sheets of a workbook should do the job. The
only problem we might face is: what if the sheets are inter-dependent
and, therefore, a sheet gets changed after it has been recalculated (by
using Worksheet.Calculate) due to recalculation in other sheet.
Thanks,
Lavneet.
--
Lavneet Singh
------------------------------------------------------------------------
Lavneet Singh's Profile:
http://www.excelforum.com/member.php...o&userid=28942
View this thread:
http://www.excelforum.com/showthread...hreadid=486765