AXISHK
asked on
Complete remove blank line in Excel
I use the below VBA code to remove the blank lines in Excel. However, it still always detects over six thousands of lines. Any idea ? How to completely remove those records ? Tks
LastRow = wkRecap.UsedRange.Rows.Cou nt
LastCol = wkRecap.UsedRange.Columns. Count
Range(Cells(2, 1).Address(RowAbsolute:=Fa lse, ColumnAbsolute:=False) & ":" & Cells(LastRow, LastCol).Address(RowAbsolu te:=False, ColumnAbsolute:=False)).De lete
LastRow = wkRecap.UsedRange.Rows.Cou
LastCol = wkRecap.UsedRange.Columns.
Range(Cells(2, 1).Address(RowAbsolute:=Fa
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER