Consulting

Results 1 to 2 of 2

Thread: Delete empty rows

  1. 09-05-2011, 01:56 PM #1
    sukumar.vb
    sukumar.vb is offline
    Banned VBAX Regular
    Joined
    Feb 2009
    Posts
    51
    Location

    Lightbulb Delete empty rows

    If in Row(n),
    Every Col(n) = "",
    Then Delete Row(n)

    I need help to convert aforesaid algorithm into VBA.
    Reply With Quote Reply With Quote
  2. 09-05-2011, 05:06 PM #2
    JWest
    JWest is offline
    VBAX Regular
    Joined
    Aug 2011
    Posts
    11
    Location
    Try:

    [VBA]
    If WorksheetFunction.CountA(Rows(n)) = 0 Then

    Rows(n).EntireRow.Delete

    Else: End If
    [/VBA]
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules