View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TimT TimT is offline
external usenet poster
 
Posts: 69
Default Selection of Range Class Failed??

Hello all...
this works in a macro but not in code..


Workbooks.Open Filename:="C:\1040WP\K1_Info.xls"
Sheets("K1_Info").Select
Range("A1:J100").Select <--- HANGS UP HERE!!
Selection.Copy
Windows("Electronic Workpapers-Final V 1.1.6.xls").Activate
Sheets("G-2").Select
Range("A11").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Range("A11").Select


Can someone tell me what I'm doing wrong?