Calculating
 

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

Calculating
 

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

Calculating
 

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

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

Calculating
 

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