had that, just turned it off to see the calcs

--


Gary


"RonaldF" wrote in message
...
Application.ScreenUpdating = False

<vba code

Application.ScreenUpdating = True 'Don't forget to put it on!!!

--
Ronald Ferdinandus
http://www.ro-pay.nl


"Gary Keramidas" wrote:

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