E excel Sep 3, 2003 #1 Hi, is it possible to create an array from all values of all range in a selection? Thanks
B Bob Umlas Sep 3, 2003 #2 Sure: 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
Sure: 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
