Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
load 2 dimensional array into excel sheet
Range("A1").Resize(UBound(arr) - LBound(arr) + 1, _
UBound(arr, 2) - LBound(arr, 2) + 1).Value = arr Alan Beban Chris wrote: Hi, I have a 2 dimensional array. I would like to load the array into a worksheet starting at lets say: A1. I know how to do this with a nested looping structure but thought maybe there was a function available in the vb or excel libraries. I tried using worksheetfuncton.transpose but it does not give the desired result. thanks Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
load 2 dimensional array into excel sheet | Excel Programming | |||
Load excel range into multi dimensional array | Excel Programming | |||
Re : Excel Sorting a 2-Dimensional Array | Excel Programming | |||
Load an array with Sheet names | Excel Programming | |||
Create One-Dimensional Array from Two-Dimensional Array | Excel Programming |