[Paul E[_2_]]

Joel,

Before adding the zoom logic I would run this w/ the updating set to false.
When I run it w/ the zoom logic, I have that commented out. So, no errors.
Also, It runs through to the end w/ the final message box and all the values
are updated. In fact, after I save and bring up the sheet again, the graphs
are all updated w/ the right new row.

W/out the zoom, I get the disappearing. W/ the zoom, all runs great and none
of the charts disappear.

"joel" wrote:


I don't understand why you need to perform a zoom. The macro should
work without zooming. I'm also not sure what excel would do when yo
uhave screen updating set to false when you try to zoom. The window may
lockup. Do you have the problem if you eliminate the ZOOM
instructions?

Another possibility is you may be getting an error in the code and the
macro may be exiting before you get to the OriginalZoom or when you set
the ScreenUpdating = True.

Check the Error setting in the VBA menu

Tools - OPtions - General - Error Trapping

I would set it to Stop on All Errors and try running the code again.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=165537

Microsoft Office Help

.