Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Consolidating two arrays into one & output to range
Brian, that works perfectly! Thanks! Yes, I'm sure my attempt lacked some logic - I'm not a trained programmer so that's how the "interesting ideas" originated :) Here's another working solution posted by Bat17 on another site: Sub KData5() Dim vaAData As Variant, vaBdata As...- jmichaelp
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Consolidating two arrays into one & output to range
Hi, I have two ranges (5k cells each) that I want to read into two arrays, combine and then output to a range. The combined array should contain the first cell of range1 and each cell of range2, the second cell of range1 and each cell of range2, etc. as follows: AX AY AZ BX BY BZ CX CY...- jmichaelp
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
