Hi Liz,

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.


Look at the Calculate method in VBA help,

From VBA help:

'---------------------------
Calculate Method

Calculates all open workbooks, a specific worksheet in a workbook, or a
specified range of cells on a worksheet, as shown in the following table.

To calculate Follow this example
All open workbooks Application.Calculate (or just Calculate)
A specific worksheet Worksheets(1).Calculate
A specified range Worksheets(1).Rows(2).Calculate
'<<---------------------------


---
Regards,
Norman



"Liz L :)" wrote in message
...
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.