Screen refresh (SOLVED)

[phantom1975]

I have some cells with formulas that don't seem to update all time. I find that if I go to a different worksheet and then back to the original, the data is updated. I was wondering if there was a Selection_Change macro that would "refresh" all the cells on the worksheet.

By the way, the formulas that are having the difficulty are just SUM formulas (=sum(F4:F200))

_________________
The only dumb question is the one that isn't asked. Pass on what you have learned.
This message was edited by phantom1975 on 2002-11-02 14:38

 

[Haluk]

Hi;

You may try this (may be you need to change the sheet name);

Sheets("Sheet1").Calculate