thanks, doing that cuts it from 30 some seconds to about 6 seconds. i
haven't tried it on the clients slow machine yet, but it took over 3 minutes
the original way.

thanks again

--


Gary


"Charles Williams" wrote in message
...
build the formulae as strings and then put them into the cells using
.formula

Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"Gary Keramidas" wrote in message
...
i have this code that loops as it build a formula

Application.Calculation = xlCalculationManual

for i = 1 to 10
Range("B4").Formula = Range("B4").Formula & "+'" & fPath & FileName$(i) &
"Trans'!$F4"
Range("C4").Formula = Range("C4").Formula & "+'" & fPath & FileName$(i) &
"Hours'!$F4"
next i

if i turn on screen updating, i can see each cell being calculated as it
builds the formula.

any way to turn of calculations so the cells aren't updated as they're
built?


--


Gary