Thanks Celia,have 2 other ?'s.
Posted by Ted on May 04, 2000 10:43 AM
That reloacte code worked great.
1st question,when using Application.ScreenUpdate=False
Is there away to have the sheet update with out having
to put Application.ScreenUpdate=True & then back to False so the
macro runs faster.
The reason is I want the sheet to update each time the code reloactes
the charts(I can have 20 or more charts on each sheet).I
saw some where about Application.ScreenUpdate=x1manual or
something like that.2nd question,can a macro run on "computer 1"
and do things to a spreadsheet on "computer2" (on a network)and if so
do you have any idea about that part of the code.
THANKS FOR ANY Help.