Thread: Need to copy specific ranges column data as row data from one worksheet to another using excel VBA
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: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
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