Question : excel vba store array and write to sheet
Answered by : fierce-ferret-wfd57feagbe7
'both these declarations will workDim arTesting As Variant Dim arTesting() As Variant arTesting = Range("A1:A12").Value
Source : https://bettersolutions.com/excel/cells-ranges/vba-working-with-arrays.htm | Last Update : Tue, 18 Aug 20
Question : excel vba store array and write to sheet
Answered by : fierce-ferret-wfd57feagbe7
Dim arMyArray() As Variant arMyArray = Range("A1:D5").Value Range("A1:D5").Value = arMyArray
Source : https://bettersolutions.com/excel/cells-ranges/vba-working-with-arrays.htm | Last Update : Tue, 18 Aug 20