VBA paste as values – how to

by

Transfer the values directly bypassing the clipboard.

Private Sub PasteChartDataQtyCompare()
    'This step pastes the range of values to the chart data tab
    with workSheets(1).Range("A6:J22")
        workSheets("Chart Data").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).resize(.rows.count,.columns.count) = .value
    end with
End Sub

More Related Contents:

  1. I am confused on purpose of using “Not”, also on matching of “If” criteria, code says “is nothing” else run code for “MsgBox”
  2. Cutting letters from alphanumeric cell entry, pasting to another cell
  3. Why MS Excel crashes and closes during Worksheet_Change Sub procedure?
  4. Detect whether Excel workbook is already open [closed]
  5. How to add a custom Ribbon tab using VBA?
  6. In Excel VBA, how do I save / restore a user-defined filter?
  7. Delete row based on partial text
  8. Way to run Excel macros from command line or batch file?
  9. Transpose multiple columns to multiple rows with VBA
  10. ExecuteExcel4Macro to get value from closed workbook
  11. How to put a tooltip on a user-defined function
  12. If WorkSheet(“wsName”) Exists [duplicate]
  13. How to merge rows in a column into one cell in excel?
  14. How to copy sheets to another workbook using vba?
  15. Autofilter with column formatted as date
  16. Excel VBA: getting row of clicked button [duplicate]
  17. VBA Many buttons point to the same _Click sub
  18. Excel VBA Filter Change event handler
  19. How to copy only values in excel vba from a range?
  20. How to suppress Update Links warning?
  21. How do we use restful APIs from Excel macros (vba)?
  22. Cannot VBA write data to cells in Excel 2007/2010 within a function
  23. How to add an attachment to an email using VBA in Excel
  24. Get Timezone Information in VBA (Excel)
  25. How to change Format of a Cell to Text using VBA
  26. Excel VBA Run-time error ’13’ Type mismatch
  27. ThisWorkbook.FullName returns a URL after syncing with OneDrive. I want the file path on disk
  28. How to query a MS-Access Table from MS-Excel (2010) using VBA
  29. How to roundup a number to the closest ten?
  30. Display a message box with a timeout value

Leave a Comment