VBA Run-time error 438 appears when “paste” runs

by

Try Selection.PasteSpecial xlPasteAll

Paste by itself works on several objects, most notably Worksheet but not on a Range object which is what your Selection is.

To paste to a Range you really have to use the PasteSpecial method with its’ available arguements such as xlPasteAll; xlPasteValues; xlPasteFormulas; xlPasteFormats and others which you can see by pressing F1 while the cursor is within PasteSpecial in the VBE.

More Related Contents:

  1. to make this code simpler
  2. VBA code takes long time to execute in excel
  3. Excel VBA deleting rows in a for loop misses rows
  4. What is the lifetime of a global variable in excel vba?
  5. Download attachment from Outlook and Open in Excel
  6. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  7. Embed picture in outlook mail body excel vba
  8. How to check for empty array in vba macro [duplicate]
  9. Use autofilter on more than 2 criteria
  10. What is the function of FormulaR1C1?
  11. Compiler Error: User-defined types not defined
  12. Open a workbook using FileDialog and manipulate it in Excel VBA
  13. Vba Excel do vlookup from a closed file
  14. excel hyperlink to nothing
  15. How to add headers to a multicolumn listbox in an Excel userform using VBA
  16. How to send files via HTTP_POST with Excel using VBA?
  17. VBA to open Excel hyperlink does not work when hyperlink generated with a formula
  18. How to Add Date Picker To VBA UserForm
  19. Vba macro to copy row from table if value in table meets condition
  20. Difference between Thisworkbook.name and Activeworkbook.name in VBA
  21. Set a cell value from a function
  22. How to determine if a date falls on the weekend?
  23. What are the differences between using the New keyword and calling CreateObject in Excel VBA?
  24. Excel VBA wildcard search
  25. VBA Check if file (from website) exists
  26. Iterating through all the cells in Excel VBA or VSTO 2005
  27. How can I display my windows user name in excel spread sheet using macros? [closed]
  28. How does Excel’s worksheet password protection work
  29. Excel VBA Project has generated multiple Workbook objects
  30. How to find a value in an excel column by vba code Cells.Find

Leave a Comment