How to get formula type in VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a property that returns whether or not the formula in a cell is an
array formula?

I can insert a formula or an array formula into a cell no problem, but
regardless of which way I insert it both the .Formula and the .FormulaArray
properties return identical strings. I would've thought that one or the
other would return empty.

The following Debug.Print statements show identical strings whether I insert
the formula string into .Formula or .FormulaArray

Range("C1").Formula = "=SUM(IF(A1:A5=1,B1:B5))"
Debug.Print Range("C1").FormulaArray
Debug.Print Range("C1").Formula

Range("C1").FormulaArray = "=SUM(IF(A1:A5=1,B1:B5))"
Debug.Print Range("C1").FormulaArray
Debug.Print Range("C1").Formula

Any ideas?
TIA
 
ActiveCell.HasArray is true if it is an array formula.

from help on HasArray

True if the specified cell is part of an array formula. Read-only Variant.
 
I have anoher doubt . I get either from these newsgroups or web a fomrula.
the author ofthe formula forgot to indicate whether the formula is a
standard formula or array formula. is there any method to test the type of
formula except by actually hitting <enter> and if it fails click F2 and hit
control+shift+enter
thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code works on sheet but not from code-to-sheet 2
Formula Error 10
#Value in FormulaArray 1
copying an array formula 2
Writing Array formulas in code 4
strange formula array issue 2
ArrayFormula in VBA 1
Format of Cell with Array Formula - Using VBA 2

Back
Top