View Single Post
 
Old 03-26-2020, 06:18 AM
NoSparks NoSparks is offline Windows 10 Office 2010
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 779
NoSparks has a spectacular aura aboutNoSparks has a spectacular aura aboutNoSparks has a spectacular aura about
Default

What you're looking to do is transpose an array.
Google is your friend, doing a search for "vba to transpose an array" gave me this as the first result returned
VBA Arrays - Transposing
Have a look at the CopyAndPasteSpecial macro.
Reply With Quote