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