Author 
Message 
dagdabrona

Posted: Fri May 21 07:33:38 CDT 2004 
Top 
Excel Programming >> 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
Excel7





Don

Posted: Fri May 21 07:33:38 CDT 2004 
Top 
Excel Programming >> 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
> 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





acarroll

Posted: Mon May 24 10:36:04 CDT 2004 
Top 
Excel Programming >> Calculating
The next rows calculation is determined by the previous rows
Thanks
Aaro
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
> 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





Don

Posted: Mon May 24 13:53:54 CDT 2004 
Top 
Excel Programming >> 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
> The next rows calculation is determined by the previous rows.
>
> Thanks,
> Aaron
>
>
>
> 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
> > 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
>
>
>





