![]() ![]() The work range or data range is the specific interval between columns that you want to target. Input the appropriate work range in the dialog window.Press F5 to compile and execute the macro.Set rng = InputRng.Cells(1, i).EntireColumn Set InputRng = Application.InputBox("Range :", xTitleId, InputRng.Address,Type:=8)įor i = To 1 Step -1 Paste the following lines of code in the window.Wait for the Microsoft Visual Basic for Applications window to appear.The first method involves using a VBA macro. But what if your imported project creates 57 empty and non-continuous columns? – For that, you’ll need an automated process. Sure, if you only have two or three empty columns, it’s quite ok to delete them manually. When it happens, deleting columns manually may not always be easy. ![]() You see this happening with CSV files and. Every now and then, the data that you import from webpages may result in a great number of columns appearing even if they’re not used.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |