copy paste values, except for values with just sum in it

[ammartino44]

Hello. I have a spreadsheet with formulas in it. There are sumifs and formulas that just have "=sum". How do I just copy and paste values over the formulas that have sumifs and leave the sums regular?

[Marc L]

Hi !

Use operator Like and Range.Formula property to check cells
(you can use instead Find method like in your other thread upon the same subject !)

and when a cell matches : .Formula = .Value …

[ammartino44]

Could you be a little more specific mr marc?

[ammartino44]

Mr Marc? Helpi me.