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