View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wayno Wayno is offline
external usenet poster
 
Posts: 1
Default Select charts to copy

I have been recently upgraded to MS XP and Excel 2002,
and now have an existing macro that fails me. It is
supposed to select 6 charts from the "Graphs" spreadsheet
but it stalls at this selection step. (Same thing
happening in my other files with a similar selection).
Is there a change needed in this command? Thanks for
your help.

Windows(DOS_current_file_name).Activate
Sheets("Graphs").Select
ActiveSheet.Shapes.Range(Array("Chart 9", "Chart 10",
_
"Chart 13", "Chart 14", "Chart 15", "Chart
16")).Select
Selection.Copy

Wayne