View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Steph[_3_] Steph[_3_] is offline
external usenet poster
 
Posts: 312
Default Range value cells with Sumif

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