Home
Manage Your Code
Snippet: Excel Transpose (VBA)
Title: Excel Transpose Language: VBA
Description: How to print your Array your created Views: 1016
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