Hide rows in multiple columns based on zero values

charlesdh · #1 06-17-2015, 11:04 AM

Hi,

As Nosparks suggested can you provide a example.
I use a "Mac" and do not get the "Mismatch".

Also, make sure you do not have "Merged" cells.

Deane · #2 06-17-2015, 11:28 PM

I found a hidden column that had a ref in it

So now the code runs without a mismatch but it is still hiding rows that have values in them. It should only hide the row if all cells in that row are zero.. ie. no values in that row.

See attachment for example of layout.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA Code to Hide columns based on selection on prior sheet	Silver1379	Excel Programming	0	04-15-2015 08:40 AM
I need to add multiple values based on multiple criteria in a cell not sure what to do	AUHAMM	Excel	3	10-27-2014 09:11 PM
Insert values from multiple rows based on value in one column	pachmarhi	Excel	3	07-18-2014 09:57 PM
Hide Rows and Update Chart based on cell value	ubns	Excel Programming	5	05-07-2012 05:44 AM
Conditional Formatting to Hide Rows or Columns?	sczegus	Excel	0	09-26-2006 04:17 PM