Advertisement
jondanson

TABLE ROW LOOP-DELETE BLANK ROWS

Apr 23rd, 2021
1,555
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.     'Delete row if no cells are populated.
  2.     For Each lRow In ActiveSheet.ListObjects(tbl).ListRows
  3.         If WorksheetFunction.CountA(lRow.Range) = 0 Then
  4.             lRow.Delete
  5.         End If
  6.     Next
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement