I apologize in advance. I'm sure there is an easy answer to this, but I can't find it here and my help option is a little screwy.

How do I make a formula into an array using VB? I know in Excel I press control, shift, and enter.