Forum Discussion
VBA - Copy only certain filtered columns without header to the last row of another sheet
Hi All, Could somebody please help. I am trying to find a VBA code that would allow to do the below: - Filter column H to keep only Completed lines in Sheet1 - Copy filtered rows for column...
Hello Subodh,
Thank you for this code, it worked for me great. I have one question on this, what would the code be if I wanted to copy the selected cells and paste special values instead of just paste?
Thank you for your time.
Ideally you should have opened a New Question.
But to give you an idea, you may try something like this...
SourceRng.Copy 'Copy the Source Range
DestRng.PasteSpecial xlPasteValues 'Paste copied range as Values