excel vba set a table to an array code example

Example 1: excel vba store array and write to sheet

Dim arMyArray() As Variant arMyArray = Range("A1:D5").Value Range("A1:D5").Value = arMyArray

Example 2: excel vba store array and write to sheet

'both these declarations will workDim arTesting As Variant Dim arTesting() As Variant arTesting = Range("A1:A12").Value