|
|
 |
| 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
>
>
>
|
| |
|
| |
|
| |
|