How to create an array formula using VB

The FormulaArray property requires R1C1 notation (according to Excel Help)

I think this will point you in the right direction:

Please Login or Register  to view this content.

Alternatively, if you're fluent in R1C1, you could use this line in the code:

Please Login or Register  to view this content.

Does that hlep?

Ron, FYI, x-posted: http://www.mrexcel.com/forum/showthread.php?t=452954

Hello SCFM,

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!