horizonger.blogg.se - Visual basic for excel array

Sub Transpose1DArr() -> Initiating a Sub Procedure named Transpose1DArr.

Now go back to the worksheet of interest and you will notice that your one-dimensional array, consisting of one column, has successfully transposed as a one-dimensional array of one row.

You can also just click on the small Play icon in the sub-menu bar to run the macro. Press F5 on your keyboard or from the menu bar select Run -> Run Sub/UserForm.Copy the following code and paste it into the code window.In the pop-up code window, from the menu bar, click Insert -> Module.Press Alt + F11 on your keyboard or go to the tab Developer -> Visual Basic to open Visual Basic Editor.Steps to transpose a one-dimensional array using VBA in Excel are shown below. VBA to Transpose One-Dimensional Array in ExcelĬonsider the following dataset of a one-dimensional array which we will be using as our example of transposing. We will also learn how to transpose an array with Paste Special Method in Excel.ġ. Arg1 = It is a required argument which is a range of cells that will be transposed.īelow in this section, we will discuss how to transpose a one-dimensional and two-dimensional array in Excel.