My
VB coding is not very good....
This code keep erroring out at the first "End If." Any
idea why?
TFTH,
Josh
' Delete the empty rows on "Active Container"
Dim rw As Long, iCol As Integer
For rw = Sheets("Active
Container").UsedRange.Rows.Count To 1 Step -1
If IsEmpty(Cells(rw, 1)) Then
If Cells(rw, Columns.Count).End(xlToLeft).Column
= 1 Then
Rows(rw).Delete
End If
End If
Next
End Sub