I can't figure out what that means!!


"Bob Phillips" wrote:

An array formula that is applied to more than one cell.

--
HTH

Bob Phillips

"ExcelMonkey" wrote in message
...
What do yo mean by part of an array of formulas? Can you give me an
example
of this?

Thanks

"Dick Kusleika" wrote:

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