Breaking News: Grepper is joining You.com. Read the official announcement!

excel vba delete rows

Add Answer

VasteMonde answered on April 28, 2020 Popularity 10/10 Helpfulness 4/10

answer excel vba delete rows

related excel vba delete rows in range

related delete rows in excel vba code

related excel vba delete empty rows

related excel delete ever other vba

excel vba delete rows

Comment

' Removes 3rd row
ThisWorkbook.Worksheets(1).Rows(3).EntireRow.Delete
' Just clear cells without removing row
ThisWorkbook.Worksheets("Feuil1").Rows(3).Cells.ClearContents

' Removes 3rd row of a range
Range("My_RANGE").Rows(3).EntireRow.Delete

Popularity 10/10 Helpfulness 4/10 Language vb

Source: Grepper

Tags: excel vba

Link to this answer
Share Copy Link

Contributed on Jan 15 2021

VasteMonde

0 Answers Avg Quality 2/10

Closely Related Answers

excel vba delete rows in range

Comment

' Removes 3rd row
ThisWorkbook.Worksheets(1).Rows(3).EntireRow.Delete
' Just to clear cells without removing the row
ThisWorkbook.Worksheets("Feuil1").Rows(3).Cells.ClearContents
' Removes 3rd row of a range
Range("My_RANGE").Rows(3).EntireRow.Delete

Popularity 10/10 Helpfulness 6/10 Language vb

Source: Grepper

Tags: excel exce

Link to this answer
Share Copy Link

Contributed on Jan 15 2021

VasteMonde

0 Answers Avg Quality 2/10

delete rows in excel vba code

Comment

Sub DeleteRowswithSpecificValue()
For i = Selection.Rows.Count To 1 Step -1
If Cells(i, 2).Value = "Printer" Then
Cells(i, 2).EntireRow.Delete
End If
Next i
End Sub

Popularity 9/10 Helpfulness 5/10 Language vb

Source: trumpexcel.com

Tags: excel exce

Link to this answer
Share Copy Link

Contributed on Apr 28 2020

Attractive Anaconda

0 Answers Avg Quality 2/10

excel vba delete empty rows

Comment

-1

' Deletes empty rows
dim rRange As Range, rowsCount As Long, i As Long
Set rRange = ActiveSheet.Range("A1:B100")
rowsCount = rRange.rows.Count
For i = rowsCount To 1 Step -1
    If WorksheetFunction.CountA(rRanges.rows(i)) = 0 Then 
        rRange.rows(i).Delete
    End If
Next

Popularity 9/10 Helpfulness 3/10 Language vb

Source: stackoverflow.com

Tags: excel exce

Link to this answer
Share Copy Link

Contributed on Feb 09 2021

VasteMonde

0 Answers Avg Quality 2/10

excel delete ever other vba

Comment

Sub Delete_Every_Third_Row()
Dim Rng As Range
Set Rng = Application.InputBox("Select the Range (Excluding headers)", "Range Selection", Type:=8)
For i = Rng.Rows.Count To 1 Step -3
If i Mod 3 = 0 Then
Rng.Rows(i).Delete
End If
Next i
End Sub

Popularity 6/10 Helpfulness 1/10 Language vb

Source: trumpexcel.com

Tags: excel vba

Link to this answer
Share Copy Link

Contributed on Feb 02 2021

Bright Booby

0 Answers Avg Quality 2/10

excel vba delete rows

Contents

More Related Answers

excel vba delete rows

Closely Related Answers

excel vba delete rows in range

delete rows in excel vba code

excel vba delete empty rows

excel delete ever other vba

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.