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.