Make my vba wait?
Hi
Put in
DoEvents
after the saves. Handy if you have anything updating the screen (e.g
charts or cell values) within code.
regards
Paul
On Jun 11, 12:15*pm, Emma Hope
wrote:
Hi all,
I have a VBA query which refreshes a workbook and then saves it, then it
changes a particular cell value and then saves it somewhere else.
Unfortunately, the first save hasn't finished before it changes the
particular cell value, so the first save is incorrect.
How can i make the vba understand i want it to wait until the previous line
of code has finished before starting the next bit?
Thanks
Emma
|