copy paste values except for formulas with =sum

[ammartino44]

Hello. I have a tab that has a bunch of sumif formulas. I want to copy paste special values all the formulas in a spreadsheet EXCEPT for the ones that are simple "SUM"= formulas. Spreadsheet attached.

[NeedForExcel]

Maybe something like this?

Please Login or Register  to view this content.

See the file attached..

[ammartino44]

This doesn't seem to be working. I just messed around and put =A3, =A4 in some cells and it doesn't paste special values. I want to do this for the entire worksheet so I'm not sure the range piece is necessary.

[ammartino44]

Oh, I think I get it. You just focused on the formulas with sumifs. That makes sense. Why do you use last cell? How does that work?

[NeedForExcel]

Hi,

You had mentioned SUMIF in Post#1 hence I focused on SUMIF..

I used the last cell cause it does not make sense to process the whole worksheet when there is no data? SpecialCells(xlLastCell) This line finds the last utilized cell and processes the loop only till then..

Let me know if you need anything else..