Thread: Calculating
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default 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