EM

Range("A1").HasArray

will return True if it has an array formula or is part of an array of
formulas.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com


ExcelMonkey wrote:
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