Formulas don't calculate
 

Hi!
I have a workbook with alot of macros. Sometimes (not always) I have
formulas (not always the same formulas) that will not calculate even
though they appear OK. I have to rebuild the dependancy tree
(ctrl+alt+shift+F9) to get them to calculate.
Since I am a novice at this (VB) I may have some bad code causing the
problem. Is there a code that will cause you to rebuild the dependancy
tree? What might it look like so I can start my search?

Thanks for any suggestions or help! And thanks for your time!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=555572

Formulas don't calculate
 

Hi Brian -

Try adding this to the end of your macro:

application.CalculateFull

If this doesn't work then try:

Add this macro to your workbook

Sub CalculateFull()
application.CalculateFull
End Sub

then add this to the end of each of your macros

application.Run "' Workbook Name .xls'!CalculateFull"

Good luck

Formulas don't calculate
 

Thanks Baron! I'll try it

--
Brian Matlac
-----------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...nfo&userid=350
View this thread: http://www.excelforum.com/showthread.php?threadid=55557

Formulas don't calculate
 

Calculate All will lead to forced calculation of all open workbooks, but it
may be not reasonably. Try the following:


Application.Calculation = xlCalculationManual
For Each rabsheet In .Worksheets
rabsheet.Activate
rabsheet.UsedRange.Calculate
Next
Application.Calculation = xlCalculationAutomatic



"xLBaron" wrote:

Hi Brian -

Try adding this to the end of your macro:

application.CalculateFull

If this doesn't work then try:

Add this macro to your workbook

Sub CalculateFull()
application.CalculateFull
End Sub

then add this to the end of each of your macros

application.Run "' Workbook Name .xls'!CalculateFull"

Good luck