Button to hide rows and columns with specific content - New Variation

[Steve Rutkey]

Hello all,

How can I examine a fixed range and Hide each row or column that has all zero values, all #N/A's, or a combination of zeros and #N/A's??? I've seen a solution that deals w/ all zero values by looking at the sum of those values (also zero of course)...and I've seen a solution that deals w/ just one zero appearing in one of the cells in a row...but is there a way to deal with the combination of zeros and #N/A's?

I'd like the solution to use a button rather than filtering.

***My request is illustrated in the attached workbook, which is a cost-estimating spreadsheet. The blue-shaded cells on the sheet "REF Titles and Rates" will fill in based on other actions the user takes on the "Detailed Estimate" sheet. Note that range E10..X15 has the blue highlights. Note also that there are some "#N/A" entries, corresponding to estimating tasks the user has not yet populated. [The "#N/A" response is actually helpful to me since it illustrates a task that needs to be completed, whereas a "0" value represents the user has added the task and entered "0".]

****Please help me to code a macro as follows:
The macro should attach to the button "TBD Will Hide Unneeded Rows & Columns":
Examine each row from 10-15
Examine the column contents in E-X in that row; if all entries are 0 or #N/A or a combination of the two, hide the row.
Then it would examine each column from E-X, checking row entries 10-15 for 0 or #N/A, and hiding the column(s).
The result would be a much-condensed display showing only the tasks and titles the user needs to see!

{I have a separate button to redisplay rows/columns; that button is working}

I greatly appreciate your input and look forward to your creative solutions!

Thank you,

Steve