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.

How to return a set number of consecutive numbers in Excel By combining ROW () and ROUND () with a couple of input values, you can create a very flexible consecutive numbering function.