I can't get a hit on Calculate Method. If I hit the F9 (Calc Now) key when
in excel, it updates the sheet. There must be code which automates this.

Please help!

Thanks,

Liz

"Norman Jones" wrote:

Hi Liz,

Look at the Calculate method in VBA help,

You can optionally, calculate a specific range, a specific worksheet or all
open workbooks.


---
Regards,
Norman


<Liz L : wrote in message
...
I am pulling data from another place which gets updated on save, however
not
just save, something on the sheet appears to need to be updated. I have
written a Module which saves the sheet on a pre defined timed interval.
The
procedure is working (without editing the sheet). But my data will not
update unless I manually change a cell anywhere on the sheet, then at the
next timed interval of Save, all my tags are updated. How do I Change a
cell
(from within my code) each pass through the timer. I beleive if the cell
automatically updated right before the save command, then my data
hopefully
will update also, as if I had manually changed the cell (I hope anyways).
The workbook is saving (with my procedure), yet it is not calculating the
cells upon save. PS - Thanks for auto timer (OnTime) to cpearson.