+ Reply to Thread
Results 1 to 3 of 3

Hide blank rows

  1. #1
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    609

    Hide blank rows

    Hi all,

    Assume you have a range where column A is filled with the products and the rest of the range with some numeric values. The problem is that there are way too many blank rows. What the code should assume as "the blank row" is:

    The whole row except column A
    The "blank" cells in a row is an IF "" statement in fact.

    Also I need a code to unhide hidden rows.

    Any ideas?

    Thanks a ton guys! See dummy...
    Attached Files Attached Files
    Last edited by ABSTRAKTUS; 01-17-2012 at 01:57 PM.

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Hide blank rows

    try this
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor ABSTRAKTUS's Avatar
    Join Date
    04-18-2010
    Location
    England
    MS-Off Ver
    Win10 Excel 2016
    Posts
    609

    Re: Hide blank rows

    Thanks mate. Spot on, your code works for me. Thanks

+ Reply to Thread

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