Copying row by row using excel VBA .

Vote count:

0

and I need help copying value from another worksheet to another, Here is the code. It won't work. I can't figure it out

Kindly advise.

Sub UpdateLinks()

Dim wbSource As Workbook Dim wbDestination As Workbook

'open the source workbook and select the source sheet Set wbSource = Workbooks.Open( _ Filename:="C:\Users\B48184\Desktop\Losses_Breakdown_by_OEE.xls")

'Set the destition workbook variable Set wbDestination = Workbooks("TryVB.xlsm")

wbSource.Sheets("Report").Range(Cells(4, 3), Cells(14, 8)).Copy wbDestination.Sheets("Sheet2").Range(Cells(4, 3), Cells(14, 8)).PasteSpecial (xlPasteAll)

Application.CutCopyMode = False

ActiveWorkbook.Save

End Sub

asked 52 secs ago

Nuzul Fikrie

1

Copying row by row using excel VBA .