|
Formulas in Arrays in VBA?
How do you get an array in VBA to pick up the formula in a cell and not the
value? |
Formulas in Arrays in VBA?
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 |
| All times are GMT +1. The time now is 12:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com