Run-time error '1004 , copy and paste

0
votes

I am trying to copy values from a range of cells in one sheet to a range of cells in another sheet.Below is my code.

wbCandidate.Worksheets(AllBOsheetName).Range(Cells(cntCandidate, 1),    Cells(cntCandidate, 32)).Copy _

Destination:=wbCandidate.Worksheets(currentSheetName).Range(Cells(cnt, 1), Cells(cnt, 32))

Any idea why I am getting below error

Run-time error '1004': Application-defined or object-defined error

1
excelvba
See if this can be any help to you stackoverflow.com/questions/28324921/… – Siva
This solved my issue. – refactor

1 Answers

0
votes

Please see this link which is talking about the same issue. https://support.microsoft.com/en-in/kb/210684