Insert Multiple columns in excel by Macro || Basic to Advance Microsoft Excel

Insert Multiple columns in excel by Macro || Basic to Advance Microsoft Excel || Learn Microsoft excel in just one minute.

Insert multiple columns by Macro code

******************************************

Sub InsertMultipleColumns()
Dim i As Integer
Dim j As Integer
ActiveCell.EntireColumn.Select
On Error GoTo Last
i = InputBox("Enter number of columns to insert", "Insert Columns")
For j = 1 To i
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromRightorAbove
Next j
Last: Exit Sub
End Sub

******************************************

Download the Code from below link

https://docs.google.com/document/d/12uwVbIT4lMCZ4xf41KL5TxqqtBBJBK5jmf0B-vrBODQ/edit?usp=sharing

*****************************************************************
Watch our other videos on conditional formatting
***********************************************************************
1) Conditional Formatting function in MS Excel - https://youtu.be/y3bBS-t6F8M
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2) Conditional formatting for specific text in Excel - https://youtu.be/pJ4UwZcq2Ck
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3) Conditional formatting top and bottom values - https://youtu.be/h1THXdzbY5s
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4) Use data bars, color scales, and icon sets to highlight data - https://youtu.be/SmmkhdhL4ZY
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
5) Conditional above and below average formatting in excel - https://youtu.be/NzmCzk_XLPs
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
6) conditional formatting Dates - https://youtu.be/fJhhfo66z5M
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
7) Unique and Duplicate Values conditional Formatting in excel - https://youtu.be/v0HtIICJLOs
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
8) Formula driven conditional formatting in excel - https://youtu.be/ZuJcYqKXDbA
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
***********************************************************************
For More Exciting video's Click on the link - https://youtube.com/playlist?list=PLzXvP7Lys7n47nE_H97_ok34Sn1atX4xR
***********************************************************************

Quickly learn Microsoft Excel advanced formulas || Learn Smartly

Learning should always be easy and fast. Codebusted videos are meant to make your learning experience smooth, easy to understand, short, and precise. Subscribe and embark on a journey of fast-track learning.


Post any technical queries, We are here to resolve your all technical query..

Write us on - https://codebusted.com

#VBA
#Macro
#Columns