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