+ Reply to Thread
Results 1 to 3 of 3

Hide Blank Rows

  1. #1
    Registered User
    Join Date
    10-06-2014
    Location
    Texas, USA
    MS-Off Ver
    2010
    Posts
    10

    Hide Blank Rows

    Hi. I'm new to forum. I need a macro that will help me hide rows that have no current data in it. I would like to email someone a portion of sheet so you can see it vs. trying to explain if that is allowed. I have one spreadsheet with several names and each name will have 12 months (12 rows). Each month I go in and filter to the current month and the names that I need and input data but not all names will end up with data for the current month and those are the rows I would love to quickly hide (not delete) at one time for the final report. The rest of my data for the prior months is hiding. Th
    Last edited by divamarsh; 10-06-2014 at 05:01 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,787

    Re: Hide Blank Rows

    I would like to email someone a portion of sheet so you can see it vs. trying to explain if that is allowed.
    Do you mean email a forum member the workbook? If so, then no, we prefer that you upload your sample workbook to the forum here.

    All questions and answers will benefit other posters like yourself when discussed in public threads. The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,065

    Re: Hide Blank Rows

    Try this Macro


    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Hide unhide blank rows?
    By jeff p in forum Excel General
    Replies: 6
    Last Post: 04-03-2012, 09:48 AM
  2. Hide blank rows
    By ABSTRAKTUS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2012, 01:56 PM
  3. Hide blank rows within a range
    By bangelta in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-04-2008, 06:41 AM
  4. Hide Blank rows
    By Charity in forum Excel General
    Replies: 15
    Last Post: 11-23-2006, 08:20 AM
  5. Hide Blank Rows
    By dee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2006, 06:35 PM

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