Results 1 to 7 of 7

Thread: Hide columns that contain 0 value

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 07-08-2025, 03:39 AM #6
    Sophian
    Sophian is offline
    Banned VBAX Newbie
    Joined
    Feb 2025
    Posts
    2
    Location
    Quote Originally Posted by DJBoY View Post
    Hi Everyone,
    Need you support to solve my issue and reduce the manual work through VBA.
    I have big sheet have more that 300 columns (all the cells contain formulas), some columns are have values and some have zero values (but it changeable next day),
    I need the VBA to search if the column has zero value and take action to hide that column. and if possible to unhide them if they have values.
    Thanks
    You can use the following VBA code to hide columns with zero values ​​and show them again when there are other values.
    Last edited by Aussiebear; 07-08-2025 at 03:46 AM. Reason: Edited out a spam link.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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