Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array
Hi,
is it possible to create an array from all values of all range in a selection? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array
Su
Dim MyArray as Variant MyArray=Range("A1:F3") msgbox Ubound(MyArray,1) 'should say 3 Msgbox Ubound(MyArray,2) 'should say 6 Range("F5:K5")=MyArray 'will copy items to this new range Bob Umlas Excel MVP "excel" wrote in message ... Hi, is it possible to create an array from all values of all range in a selection? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex conditional summing - array COUNT works, array SUM gives#VALUE | Excel Worksheet Functions | |||
Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
Prevent cell/array references from changing when altering/moving thecell/array | Excel Discussion (Misc queries) | |||
meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) |