Insert rows
Closed
Arié
-
May 30, 2010 at 12:29 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 30, 2010 at 03:18 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 30, 2010 at 03:18 AM
Related:
- Insert rows
- Insert check mark in word - Guide
- How to insert photo in word for resume - Guide
- Insert draft watermark in word on all pages - Guide
- Insert key on laptop - Guide
- Insert gif in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 30, 2010 at 03:18 AM
May 30, 2010 at 03:18 AM
Sub InsertColumn() Dim Row As Integer For Row = 10 To 1 Step -1 If (Row = 1) Then Cells(Row, 1).EntireRow.Insert ElseIf (Cells(Row, 1).Text <> Cells(Row - 1, 1).Text) Then Cells(Row, 1).EntireRow.Insert End If Next Row End Sub