Thread: Macro to paste in another workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon[_21_] Jon[_21_] is offline
external usenet poster
  
Posts: 37
Default Macro to paste in another workbook
Fixed!

I just had to do

Workbooks.Open "Archivefile.xls"

set rng = Workbooks("Archivefile").Sheets("Archive") _
.Cells(Rows.Count, 1).End(xlUp)(2).Offset(3, 0)

Works just like I wanted it to.

Reply With QuoteReply With Quote