Like lots of cells all at once?

Dim myArr As Variant
myArr = ActiveSheet.Range("C1:c10").Formula

This is 10 row by 1 column array.

Jon wrote:

How do you get an array in VBA to pick up the formula in a cell and not the
value?

--

Dave Peterson