It means that instead of the formula being applied to just one cell, it is
applied to many.
--
HTH
Bob Phillips
"ExcelMonkey" wrote in message
...
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