Creating array formulaes in macro

G

Guest

Hi all,

I have a simple question... When I create an array formulae, I press
Ctrl+Shift+Enter to make it function correctly. My question is if I want to
create an array formulae in VB Editor then what code will facilitate me in
doing that.

REgards
Raj
 
B

Bob Phillips

Raj

Use the FormulaArray property, example

ActiveCell.FormulaArray = "=SUM(IF(A1:A10=""a"",B1:B10))"
 

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

Issue Adding an Array Formula to a cell at Runtime. 4
Array follow up 1
formula to count text entries and return text with most entries 8
Error while using SUMPRODUCT function 3
Array Formula 3
Array function does not seem to work 19
hlookup in array 2
Formulas fail to calculate 3

Top