array in VBA

J

Jack Sons

Hi all,

A few days ago I saw an answer to a post that showed the VBA equivalent of
using an array worksheet formula with ctrl+shift+enter. I forgot to copy
that answer for later use, now I can't find it anymore. Anybody who knows
what I mean? If so, please tell me where to find the post.

Jack Sons
The Netherlands
 
J

Jack Sons

Don,

Do I understand it right:

Cells("H5").FormulaArray=

will do in VBA the same as array entering (with ctrl+shift+enter) a formula
in H5?

Jack
 
D

Dave Peterson

Try it and you'll soon see!



Jack said:
Don,

Do I understand it right:

Cells("H5").FormulaArray=

will do in VBA the same as array entering (with ctrl+shift+enter) a formula
in H5?

Jack
Click to expand...
 
Top