vba paste not working

by

The reason it fails on that line of code is that there is no Paste method for the Range object.

There are 2 ways to copy paste.

1) Send a value to the Destination parameter in the Copy method. You then don’t need a Paste command:
wb.Sheets("Answers_Source").Range("h1:z160").Copy _
Destination := wb2.Sheets("Answers").Range("h1:z160")

2) Use the PasteSpecial method on the destination range after copying, which by default pastes everything, like a standard paste.

wb2.Sheets("Answers").Range("h1:z160").PasteSpecial

Then to stop the Marquee (or marching ants) around the cell you copied, finish with Application.CutCopyMode = False

More Related Contents:

  1. Loop through files in a folder using VBA?
  2. How to error handle 1004 Error with WorksheetFunction.VLookup?
  3. How can Excel VBA open file using default application
  4. How to compare two entire rows in a sheet
  5. Run same excel macro on multiple excel files
  6. how to detect whether VBA excel found something?
  7. VBA : save a file with UTF-8 without BOM
  8. Saving a Excel File into .txt format without quotes
  9. Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”
  10. Determine if cell contains data validation
  11. VBA – Range to jpg picture
  12. Fastest way to delete rows which cannot be grabbed with SpecialCells
  13. Combine multiple Excel workbooks into a single workbook
  14. Excel Macro, inserting internationally valid formula during run-time
  15. Making VBA Form TextBox accept Numbers only (including +, – and .)
  16. VBA Convert date to week number
  17. Inserting an Online Picture to Excel with VBA
  18. Change length of For loop while in the loop
  19. VBA – Run Time Error 1004 ‘Application Defined or Object Defined Error’
  20. Consolidating worksheets into one
  21. Copy filtered data to another sheet using VBA
  22. mac excel vba loop : from list & then export as pdf
  23. Can Advanced Filter criteria be in the VBA rather than a range?
  24. In Excel VBA, what is the way to check if the web page is fully loaded?
  25. Excel Useform: How to hide application but have icon in the taskbar
  26. Reading Web Pages using Excel VBA
  27. Excel VBA: auto click and open file from website
  28. How do I get a list of unique values from a range in Excel VBA?
  29. How to get selected value in multicolumn listbox
  30. Query my excel worksheet with VBA

Leave a Comment