Calculate Selected Cells Only?

[fruitchunk]

I have a heavy excel workbook with lots of formulas, every time I did
something it was calculating literally for 20mins, so I changed it to Manual
Calculate. Now lets say I add a column and do calculate now it calculates the
whole sheet/workbook for a very long time. Can I tell it to only calculate
the new cells ? or maybe can I have excel calculate only selected cells?

Thanks

 

[Ms-Exl-Learner]

Have a look in the below link for more details.

http://www.decisionmodels.com/calcsecretsg.htm

Remember to Click Yes, if this post helps!

 

[fruitchunk]

I guess I need some kind of VBA code or macro to do Range.Calculate.
Can you help me with that?

 

[Ms-Exl-Learner]

Go through the below link for VBA code.

http://www.decisionmodels.com/calcsecretsh.htm

Remember to Click Yes, if this post helps!
------------------------
(Ms-Exl-Learner)
------------------------

I guess I need some kind of VBA code or macro to do Range.Calculate.
Can you help me with that?