So, maybe you can copy the formulas down and then change to values. Here is
one I use to get a running balance. Try this idea.

Sub balance()
Set frng = Range("h8:h" & Range("a65536").End(xlUp).Row)
With frng
.Formula = "=h7+d8"
.Formula = .Value
End With
End Sub

--
Don Guillett
SalesAid Software

"Aaron" wrote in message
...
The next rows calculation is determined by the previous rows.

Thanks,
Aaron


----- Don Guillett wrote: -----

Why? Wouldn't it be better to turn off all calculation at the start
of your
macro and turn it back on at the end.
Application.Calculation = xlCalculateManual
your code
Application.Calculation = xlCalculateautomatic
--
Don Guillett
SalesAid Software

"Aaron" wrote in message
...
Hi All,
I am trying to have VBA fill down a formula in a column but, I
need it to
check to see if the Formula is done calculating before moving to the
below
cell. Any ideas?
Thanks in advance,
Aaron