$$Excel-Macros$$ Re: VBA - Access multiple Excel instances

2009-09-12 Thread Dave Bonallack
to read them all. Dave. Date: Fri, 11 Sep 2009 07:06:48 -0700 Subject: $$Excel-Macros$$ Re: VBA - Access multiple Excel instances From: paul...@gmail.com To: excel-macros@googlegroups.com Hi Dave, In a way that was my problem, dispite the fact that I had calculation set to manual the sheet

$$Excel-Macros$$ Re: VBA - Access multiple Excel instances

2009-09-11 Thread Dave Bonallack
Hi, Can't you just set calculations to manual while you do the Goal Seek? Dave. Date: Fri, 11 Sep 2009 03:33:04 -0700 Subject: $$Excel-Macros$$ VBA - Access multiple Excel instances From: paul...@gmail.com To: excel-macros@googlegroups.com Hi, I have a very large large spreadsheet

$$Excel-Macros$$ Re: VBA - Access multiple Excel instances

2009-09-11 Thread PMC1
Hi Dave, In a way that was my problem, dispite the fact that I had calculation set to manual the sheet with the large large table was still recalculating at each iteration! I've managed to get around it by explicitly turning off calculation on that sheet during the goal seek using