vba excel如何粘贴没有font / color / bg颜色格式的值

I've got a macro to copy a summary row from each of a series of worksheets. The summary row is specially formatted with font/font color/bg color, but when pasted into the 'sumamry sheet', it needs to just paste values without formatting. I've got a macro to copy a summary row from eac