Dear Team,
If column B&C value is blank then i want to delete the specific row cells from A to H only.
Code
Dim rngBlanks As Range
Dim i As Integer
For i = 2 To 3
On Error Resume Next
Set rngBlanks = Columns(i).SpecialCells(xlCellTypeBlanks)
On Error GoTo 0
If Not rngBlanks Is Nothing Then
rngBlanks.EntireRow.Delete
End If
Next
In above code instead of Entire row, how can i mention column A to H
Kindly advice me for the above problem