Скачать или смотреть Insert Multiple rows in excel by Macro || Basic to Advance Microsoft Excel

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

Insert multiple rows by Macro code

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

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

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

Download the Code from below link

https://docs.google.com/document/d/1S...

*****************************************************************
Watch our other videos on conditional formatting
***********************************************************************
1) Conditional Formatting function in MS Excel -    • Conditional Formatting function in MS Exce...  
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2) Conditional formatting for specific text in Excel -    • Conditional formatting for specific text i...  
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
3) Conditional formatting top and bottom values -    • Conditional formatting top and bottom valu...  
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
4) Use data bars, color scales, and icon sets to highlight data -    • Use data bars, color scales, and icon sets...  
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
5) Conditional above and below average formatting in excel -    • Conditional above and below average format...  
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
6) conditional formatting Dates -    • conditional formatting Dates || Basic to A...  
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
7) Unique and Duplicate Values conditional Formatting in excel -    • Unique and Duplicate Values conditional Fo...  
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
8) Formula driven conditional formatting in excel -    • Formula driven conditional formatting in e...  
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
***********************************************************************
For More Exciting video's Click on the link -    • Excel - Fast track  
***********************************************************************

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
#Rows