View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wouter HM Wouter HM is offline
external usenet poster
 
Posts: 99
Default Can I get Excel to recalculate just one cell?

Hi Prof Wonmug,

Try This

Open Tools - Options
Goto tab Calculation
Select option Manual
Click OK


If you have the line of code below comment it out:
Application.Volatile

Use the F2 option as before

HTH,

Wouter