Calculating

[Guest]

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

 

[Don Guillett]

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
(e-mail address removed)

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?

 

[Guest]

The next rows calculation is determined by the previous rows

Thanks
Aaro


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

Why? Wouldn't it be better to turn off all calculation at the start of you
macro and turn it back on at the end
Application.Calculation = xlCalculateManua
your cod
Application.Calculation = xlCalculateautomati
--
Don Guillet
SalesAid Softwar
(e-mail address removed)

Hi All

check to see if the Formula is done calculating before moving to the belo
cell. Any ideas

 

[Don Guillett]

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