Results 1 to 3 of 3

Filter Shows Blank Rows in Selection

Threaded View

  1. #1
    Registered User
    Join Date
    06-03-2008
    Posts
    16

    Exclamation Filter Shows Blank Rows in Selection

    Hello
    i Have a problem. I want to delete all (blank) rows from my Excel Sheet. I have written the code like this.
    With ActiveSheet
    iLastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
    
    If (Sheets("PivotTable").Cells(iLastRow - 1, 1).Value = "(blank)") Then
        Sheets("PivotTable").Rows(iLastRow - 1).Hidden = True
    End If
    
    End With.
    This Code does not shows blank rows at first time. but when i select any other value from filter it starts to show (blank)......

    Pls help me to solbe this..........as its very urgent
    Last edited by royUK; 06-11-2008 at 07:47 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1