Sorry everyone - reading my original post I realize I was quite vague! I
would like to find all cells that have a sumif in them, and then range-value
the cells. So essentially, remove the formula and hardcode the result in
the cell. As if I were to select a cell, copy and paste special values.
Thanks!!


"bhofsetz" wrote in
message ...

whoops, forgot to paste the code in:
try this:


Code:
--------------------
Sub FindSumIf()
Cells.Find(What:="sumif", After:=ActiveCell, LookIn:=xlFormulas, LookAt
_
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False).Activate
MsgBox ActiveCell.Value
End Sub
--------------------


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile:
http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=381401