VBA Paste

[kgkev]

Stuck again i'm afraid.

User manually copies a complete work book, Then clicks a macro enabled button to paste the data into the current work book.

Workbooks("Template.xlsm").Range("A1").Paste Destination:=Workbooks("Template.xlsm").Sheets("INVOICE").Range("A1")

however it gives a subscript out of range error.

is it not possible to carry do a copy outside of a macro and the paste inside?

 

[Jeffrey Mahoney]

Please use something like this and see if you get better results:

Sub PasteIntoCurrentWB()
  Dim TWB As Workbook
  Dim Sht As Worksheet
  Dim Cel As Range
  
  Set TWB = ThisWorkbook
  Set Sht = TWB.Sheets("Invoice")
  Set Cel = Sht.Range("A1")
  
  Cel.PasteSpecial xlPasteAll
  
  
End Sub