Calculating

A

Aaron

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
 
D

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
[email protected]
Aaron said:
Hi All,

I am trying to have VBA fill down a formula in a column but, I need it to
Click to expand...
check to see if the Formula is done calculating before moving to the below
cell. Any ideas?
 
A

Aaron

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
[email protected]
Aaron said:
Hi All
Click to expand...
check to see if the Formula is done calculating before moving to the belo
cell. Any ideas
 
D

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
 
Top