In this step you can enter the row number per your demands. Step 6: Enter 4 into “ Enter Row Number”. In this step you can select the long list range you want to do split. Select ‘ SplitDataintoMultipleColumns’ and click Run. Step 4: Click Developer->Macros to run Macro. ![]() And then quit Microsoft Visual Basic for Applications. Step 3: Save the codes, see screenshot below. ![]() OutputRng.Resize(UBound(xArr, 1), UBound(xArr, 2)).Value = xArr Set OutputRng = Application.InputBox("Select Output Range :", xTitleId, Type:=8) XRow = Application.InputBox("Enter Row Number :", "SplitDataintoMultipleColumns") Set InputRng = Application.InputBox("Select Input Range :", "SplitDataintoMultipleColumns", InputRng.Address, Type:=8) Step 2: In Microsoft Visual Basic for Applications window, click Insert->Module, enter below code in Module1: Sub SplitDataintoMultipleColumns() Or you can enter Microsoft Visual Basic for Applications window via Developer->Visual Basic. Select View Code, Microsoft Visual Basic for Applications window pops up. ![]() Step 1: On current visible worksheet, right click on sheet name tab to load Sheet management menu. Method 1: Split Data into Multiple Columns by VBA in Excel ![]() If we want to split them into 4 rows, we can follow below steps.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |