+ Reply to Thread
Results 1 to 4 of 4

VBA code to Hide Row if ALL cells in range are empty

  1. #1
    Registered User
    Join Date
    01-15-2024
    Location
    Dubai, UAE
    MS-Off Ver
    2021
    Posts
    3

    VBA code to Hide Row if ALL cells in range are empty

    Hello, everyone. Can you please assist with the issue?
    I have a code for macros assigned to the button. I need it when the button is pressed then several ranges are checked and if there are rows which are fully empty they should be hidden. But In fact with my code below ALL rows in range become hidden after pressing the button. Can you help me finding the solvation for that?

    Administrator's note: Please take the time to review our rules. There aren't many, and they are all important. Our guidelines recommend code tags. I have added them for you this time because you are a new member. --6StringJazzer
    Please Login or Register  to view this content.
    I am attaching full file here. The button is in report Sheet.1.xlsm
    Last edited by 6StringJazzer; 02-08-2024 at 08:59 AM. Reason: please use code tags

  2. #2
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    935

    Re: VBA code to Hide Row if ALL cells in range are empty

    Try my new testing method. Note that it seems to me that you have overlapping ranges, please check.
    Please Login or Register  to view this content.
    Difficult is not to know but to share what you know (Han Fei Tzu reworked)

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,720

    Re: VBA code to Hide Row if ALL cells in range are empty

    Give this a try

    Please Login or Register  to view this content.
    Last edited by alansidman; 02-08-2024 at 07:45 PM.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,720

    Re: VBA code to Hide Row if ALL cells in range are empty

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    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 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] Code to Highlight Empty Cells in Range
    By RSa in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-21-2019, 10:47 PM
  2. [SOLVED] Stop code from running when a range of cells are empty.
    By Neuk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-22-2018, 04:09 PM
  3. [SOLVED] Auto hide/unhide rows that have empty cells ( Preferably VBA Code)
    By carlandtina02 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-09-2016, 07:06 PM
  4. [SOLVED] VBA Code to Check if a Range of cells is Empty or Not and run code accordingly
    By unit285 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-01-2016, 08:19 PM
  5. Amend code to do nothing if cells in a range are empty
    By nickmax1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-05-2015, 07:38 AM
  6. Replies: 0
    Last Post: 03-20-2014, 11:51 AM
  7. Hide empty cells in this code
    By JanF in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-14-2014, 04:12 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1