Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |