Forum Discussion
Solved
How to VBA Copy Paste Special Values
The below code simply copies and pastes the filtered information, and can someone tell me what the below code should look like to copy and paste special values instead of paste only, thanking you in ...
Using Copy and PasteSpecial:
wsData.Range("D2:E" & lr).SpecialCells(xlCellTypeVisible).Copy
wsDest.Range("C" & Rows.Count).End(3)(2).PasteSpecial Paste:=xlPasteValues
Please note that this consists of two separate lines.
Using Copy and PasteSpecial:
wsData.Range("D2:E" & lr).SpecialCells(xlCellTypeVisible).Copy
wsDest.Range("C" & Rows.Count).End(3)(2).PasteSpecial Paste:=xlPasteValues
Please note that this consists of two separate lines.