LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Coverting a VBA array from 2-D to 1-D

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Coverting to minutes Gostwin Excel Discussion (Misc queries) 2 June 5th 08 10:02 PM
coverting h:mm to decimal richzip Excel Discussion (Misc queries) 2 February 15th 08 07:42 PM
Coverting seconds into hr:min:sec jsturino Excel Discussion (Misc queries) 3 March 24th 06 08:00 AM
Coverting time Kim Excel Worksheet Functions 1 September 20th 05 01:24 AM
Coverting array data into single column dgarg Excel Worksheet Functions 4 December 15th 04 07:43 AM


All times are GMT +1. The time now is 02:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"