Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: Excel Transpose (VBA)
Title: Excel Transpose Language: VBA
Description: How to print your Array your created Views: 820
Author: p maheshwari Date Added: 4/22/2010
Copy Code   
1Range("aa2:aa20") = WorksheetFunction.Transpose(opp)
2
3
4Here opp() is my array of 20 objects
5
6To make it little bit dynamic I can define last row variable by 
7
8lastrow = a2.end(xldown).row
9
10
11
12