View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] cjwenngatz@gmail.com is offline
external usenet poster
 
Posts: 9
Default Cut and Paste Macro.

So I'm having an inputbox pop-up so I can have the data from that sheet
cut and pasted into the new sheet. It all seems to work, but the paste
portion always errors out. Any ideas what I'm doing wrong?

Thanks!

Workbooks.Open Filename:=strFile
Selection.CurrentRegion.Select
Selection.Copy
ActiveWindow.Close
Worksheets("All Movements").Select
Range("A1").Select
ActiveSheet.Paste