Tag Archives: writing arrays

I have covered the topic of writing VBA arrays to a spreadsheet range quite frequently here.  As a reminder, the procedure is: ReDim myarray(1 To NumArrayRows, 1 To NumArrayColumns) ‘ Fill array With Range(“MyNamedRange”) .ClearContents .Resize(NumArrayRows, NumArrayColumns).Name = “MyNamedRange” End … Continue reading →