Paste range but retain destination formatting

[HotLanta]

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

 

[JLGWhiz]

You will have to reformat the range if you use the xlFilterCopy method. There is no parameter built into the AdvancedFilter function that would allow for formatting.

 

[HotLanta]

I was afraid of that... Thank you for your help

 

[JLGWhiz]

I was afraid of that... Thank you for your help

You're welcome,
Regards, JLG