Member Avatar for bren1519
bren1519 0 Newbie Poster

Hi,

This is what I am trying to accomplish:

If the value of a cell is zero in any of the cells in the range of C11-C25, then hide that row. The data is being populated with an embedded query and I also need the row to then unhide if the value on the next refresh changes from zero to a value. The same macro would apply to 75% of the worksheets in the workbook but not to all so is there a way to run one macro for a range of worksheets?

thx for any help!
Brenda

  • 1 Contributor
  • 0 Replies
  • 45 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.