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.