Automating the selection process isn't difficult if you rely on VBA's InputBox in Microsoft Excel.

Application.InputBox method (Excel) Displays a dialog box for user input. Returns the information entered in the dialog box.

Inserting a lot of columns or rows in Microsoft Excel is awkward and prone to mistakes. When you need to enter dozens or more columns, use this VBA procedure for ease and accuracy.