Thread
:
Calculating
View Single Post
#
4
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]