View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default Finding Array Formulas in VBA

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