1. Sekolah Dasar
  2. Sekolah Menengah Pertama
  3. Sekolah Menengah Atas
  4. Mata Pelajaran
  5. Programming

Excel Vba Delete Rows In Range

[Solved] Excel Vba Delete Rows In Range | Vb - Code Explorer | yomemimo.com
Question : delete rows in excel vba code

Answered by : attractive-anaconda-auyq8jrkli4a

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

Source : https://trumpexcel.com/vba-delete-row-excel/ | Last Update : Tue, 05 May 20

Question : excel vba delete columns in range

Answered by : vastemonde

' Deletes 3rd column
ThisWorkbook.Worksheets(1).Columns(3).EntireColumn.Delete
' Deletes 3rd column in range
Range("My_RANGE").Columns(3).EntireColumn.Delete

Source : | Last Update : Fri, 22 Jan 21

Answers related to excel vba delete rows in range

Code Explorer Popular Question For Vb