Hi all,
I am new to using the paste range function and I can't seem to figure out how to paste the range without overwriting the formatting of the destination sheet formatting. Below is the code I am using. Can it be modified to paste values only?
Thank you.
Range("Datalist").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _
"A4:M4"), Unique:=False
I am new to using the paste range function and I can't seem to figure out how to paste the range without overwriting the formatting of the destination sheet formatting. Below is the code I am using. Can it be modified to paste values only?
Thank you.
Range("Datalist").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _
"A4:M4"), Unique:=False