+ Reply to Thread
Results 1 to 4 of 4

VBA Hiding Rows Within a Specific Range - Cells Containing Blanks

  1. 04-07-2023, 05:21 PM #1
    brentjohn
    brentjohn is offline
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    500

    VBA Hiding Rows Within a Specific Range - Cells Containing Blanks

    Greetings,
    I have been working on this for most of the day. I am wanting to hide rows within a Range with a specific cell is blank.
    For example: Sheet24.Range ("F18:F270"), Sheet24.Range ("F274:F526"), and so forth. The following code searches the entire worksheet.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 04-07-2023, 06:35 PM #2
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,426

    Re: VBA Hiding Rows Within a Specific Range - Cells Containing Blanks

    Maybe just change this
    Please Login or Register  to view this content.
    To this
    Please Login or Register  to view this content.
    Adjust similarly for the other ranges.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 04-08-2023, 06:41 AM #3
    brentjohn
    brentjohn is offline
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    500

    Re: VBA Hiding Rows Within a Specific Range - Cells Containing Blanks

    TMS,
    Works great!!!
    Thank you much!!
    Reply With QuoteRegister To Reply
  4. 04-08-2023, 06:43 AM #4
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,426

    Re: VBA Hiding Rows Within a Specific Range - Cells Containing Blanks

    You're welcome.



    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replace cells with “NA” where records are blanks in specific column in specific/ variable
    By RavindraK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-16-2021, 02:35 AM
  2. [SOLVED] Delete all blanks rows in specific range on all worksheets
    By Dumy in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-01-2015, 03:06 PM
  3. Counting consecutive cells in a range with blanks and displaying a specific value
    By mvllanueva14 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-28-2014, 01:10 AM
  4. Hiding Rows in Pivot Table with specific value range
    By eugeneevans in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-22-2014, 04:42 PM
  5. [SOLVED] First unhide all rows - then hide rows based on specific cell value for a range of cells
    By robbiekh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-22-2013, 05:46 PM
  6. Hiding/un-hiding non-specific rows and specific columns
    By MusicMusic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2008, 09:54 PM
  7. [SOLVED] Hiding rows containing zeroes or blanks in pivot tables?
    By ChrisBusch in forum Excel General
    Replies: 2
    Last Post: 06-01-2005, 10:05 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1