|
|
|
|
#1
06-17-2015, 06:29 AM
|
|||
|
|||
The macro Charles provided runs fine for me.
The macro will be hiding the row prior to the mismatch. Try changing the code line of cell.EntireRow.Hidden = True to cell.Select and run the macro. This time when you get the mismatch error I'd suspect whatever is in the next cell to be selected to be causing the problem. Have a look and see what's there. 
|
|
| Tags |
| hide, rows and columns, zero values |
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode