How do you get an array in VBA to pick up the formula in a cell and not the value?
J Jon Dec 1, 2006 #1 How do you get an array in VBA to pick up the formula in a cell and not the value?
D Dave Peterson Dec 1, 2006 #2 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.
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.
