We wanted to transpose a range of array A1:B6.
Step 4: We need to specify the argument for Transpose function. Sheets("Example #2").Range("D1:I2").Value = WorksheetFunction.Transpose( Step 3: Use WorksheetFunction.Transpose to be able to assign an array A1:B6 to transpose function. I would be saving the transposed array into cell D1 to I2. Step 2: Decide the range where you want to transpose this data. Step 1: Define a sub-procedure to store a macro. After transposing, it would be an array with two rows and six columns.įollow the below steps to use Transpose in VBA.
This is a two-dimensional data with six rows and two columns. Suppose you have a two-dimensional array of employees and their salaries as below: Example #2 – VBA Transpose of two-dimensional Array You can see that the given array of the list is transposed into one single column and stored under cell A1 to A5. Step 6: Hit F5 or Run button under VBE to run this code and see the output under active excel spreadsheet. Here, we have defined a code which will allow the system to transpose the data in list array called Arr1 and then store it under cell A1:A5 on the active worksheet. Step 5: Use on the given array to be able to transpose the list defined under Arr1 variable. Step 4: Now use the Range.Value method to define the range in which these values you wanted to get pasted. This would be the list you wanted to paste in your excel sheet.Īrr1 = Array("Lalit", "Sneha", "Ethyl", "John", "Cory") Step 3: Define the list as an array using the Array function. Step 2: Define a new variable which can hold your one-dimensional array. Step 1: Insert a new module and define a new sub-procedure to create a macro in VBA.
0 kommentar(er)
