Member Avatar for divakar.it

I would like to copy and paste special values in excel using VB6 during report generation. But pastespecial is not working. Its throwing error 1004 Paste Special method worksheet failed.

Below is the code. can you please advise

xlTmp.ActiveSheet.Range("H7:H23").Select
xlTmp.Selection.Copy
xlTmp.Sheets("Consolidation").Activate
xlTmp.ActiveSheet.Cells(6, 4).Value = P(N)
xlTmp.ActiveSheet.Cells(8, PS).Select
xlTmp.ActiveSheet.PasteSpecial xlPasteValues, xlNone, False, False
  • 2 Contributors
  • 3 Replies
  • 206 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by AndreRet
Member Avatar for AndreRet

I think the problem might be with the range not specified. Try the following -

xlTmp.Activesheet.Range("A1").PasteSpecial Paste:=xlValues, xlNone, False, False
Member Avatar for divakar.it

Thanks.. this works fine now..

Member Avatar for AndreRet

Only a pleasure. Happy coding.:)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.