View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default Finding Array Formulas in VBA

How do you search a cell for array formulas? Using the "{" as a search term
in Excel's Find does not seem to do it. Is ther a way in VBA to find these?

{=MAX(IF(MONTH(E6:E12)=F14, F6:F12, 0))}

Thanks