• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA to hide row if no value in any cell of that row

A

ALAMZEB

Member
Hi


I have list of 140 products and my table consist of changes made to them in this period only.


On average the changes are made to 7 products only which varies


Can macro be generated that always hide row if there are no value in cell from column AM to BC


The cell have formulas but value can be greater or less than zero


Attached spread sheet as sample


If anyone can provide that macro that would be great and highly appreciated
 

Attachments

  • macro sample.xlsx
    17.6 KB · Views: 2
Hi Narayan

thst great but can we make it event generated macro so I don't have clock button everytime I update product
 
Hi narayan

In addition to top, there are values after column 54. in this case if I have any value or text in column CN, macro doesn’t hide that row
 
You must log in or register to reply here.
Back
Top