Thread: Macro Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Carl is offline
external usenet poster
 
Posts: 361
Default Macro Problem

I am trying to use this macro to copy and paste a section of my spreadsheet.
It get;s hung up at the indicated line:

Range("A1:j29").Select

Application.CutCopyMode = False

Selection.Copy

Windows("OCC_Top10.xls").Activate

Range("A1").Select



HUNG UP Here

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _

:=False, Transpose:=False





Application.CutCopyMode = False

What am I doing incorrectly ?

Thank you in advance.