Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I know I can quickly map a 2d range to an array with code such as
Sub MyArr() Dim myarray myarray = [A1:D2] End Sub Is there a quick way to convert the array into a single dimension without using a FOR loop? I want to end up with an array of two elements, the first containing a concatenated string of A1 to D1 the second of A2 to D2. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Coverting to minutes | Excel Discussion (Misc queries) | |||
coverting h:mm to decimal | Excel Discussion (Misc queries) | |||
Coverting seconds into hr:min:sec | Excel Discussion (Misc queries) | |||
Coverting time | Excel Worksheet Functions | |||
Coverting array data into single column | Excel Worksheet Functions |