Or as Jerry points out........use ThisWorksheet instead of Activesheet.


Gord

On Sat, 10 Mar 2007 15:36:35 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

I am not sure how to overcome that problem other than to turn calculation to
manual when you switch sheets.