How to copy only values in excel vba from a range?

by

You can skip the copy command altogether by assigning the values of the source range to your destination range:

'Source range
Set r = Sheets("Sheet1").Range("Table1")
'Destination range
Set dest = Range(.Cells(linhaAtual, 1), .Cells(linhaAtual + r.Rows.Count - 1, 5))

dest.Value = r.Value

More Related Contents:

  1. Is the . in .Range necessary when defined by .Cells?
  2. Convert an entire range to uppercase without looping through all the cells
  3. Detect if range is empty
  4. How to copy data from closed workbooks (keeping them closed) into master workbook using VBA?
  5. Copy a selected range to another worksheet
  6. VBA Dialog box to select range in different workbook
  7. VBA: Modify chart data range
  8. Format Cell Contents
  9. Excel formula checklist in employees
  10. How do I put double quotes in a string in vba?
  11. Excel VBA – How to add dynamic array formula
  12. How can I URL encode a string in Excel VBA?
  13. VBA – Write all possible combinations of 4 columns of data [duplicate]
  14. Remove duplicates from array using VBA
  15. 2 ways for “ClearContents” on VBA Excel, but 1 work fine. Why? [duplicate]
  16. How to automatically insert a blank row after a group of data
  17. How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
  18. Export chart as image – with click of a button
  19. Error13 in Excel VBA in data file
  20. How to get the path of current worksheet in VBA?
  21. Excel VBA to match and line up rows
  22. Change font color for a part of text in cell
  23. Create a new object using the text name of the class
  24. Excel cell from which a Function is called [duplicate]
  25. How to extract text within a string of text
  26. GET pictures from a url and then rename the picture
  27. Create Chart from Array data and not range
  28. How to check whether certain sheets exist or not in Excel-VBA? [duplicate]
  29. Excel – Using COUNTIF/COUNTIFS across multiple sheets/same column
  30. Delete all data rows from an Excel table (apart from the first)

Leave a Comment