lkumar
08-21-2019, 08:46 AM
Hi
I am new in VBA and trying to make the one workbook range value equal another workbook range value as below.
ActiveWorkbook.Sheets("Destination").Range(Cells(2, 1), Cells(25, 1)).Value = ActiveWorkbook.Sheets("New").Range(Cells(5, 1), Cells(28, 1)).Value
This code is giving error.
Runtime error '1004'
Method range of object worksheet failed
Can some one provide the solution of it.
I am new in VBA and trying to make the one workbook range value equal another workbook range value as below.
ActiveWorkbook.Sheets("Destination").Range(Cells(2, 1), Cells(25, 1)).Value = ActiveWorkbook.Sheets("New").Range(Cells(5, 1), Cells(28, 1)).Value
This code is giving error.
Runtime error '1004'
Method range of object worksheet failed
Can some one provide the solution of it.