Calculate Selected Cells Only?

  • Thread starter Thread starter fruitchunk
  • Start date Start date
F

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
 
I guess I need some kind of VBA code or macro to do Range.Calculate.
Can you help me with that?
 
Back
Top