VBA Array Formulae

  • Thread starter Thread starter Loomah
  • Start date Start date
L

Loomah

Hi
How can I write an array formula in VBA? I know how to put an array formula
into a worksheet but I'd like to get the result without having to do that.

More specifically I'd like to get the result from the following formula and
assign it to a variable without writing it to a cell

{=max(len(a1:a1000))}

TIA
;-)
 
Just a caveat: In the past, I found evaluating array formulas in VBA to be
"flaky". One day the formula will work, the next day it doesn't, though there
have been no changes to the code in the interim. I haven't tried them in the
last couple of versions, so the problem may have been remedied.
 

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

Excel Need Countifs Formula Help 0
Delete rows based on contents of Col A 0
VBA IIf(myCell.Value = Array(myCell2(1).Value, myCell2(2).Value,myCell2(3).Value,myCell2(4).Value) , 2
Excel VBA 1
array formula question 4
copying an array formula 2
Evalute Array Formula in VBA code 2
Scalar Multiplying VBA Array 8

Back
Top