|
|
|
|
#1
06-11-2015, 08:51 PM
|
|||
|
|||
Mismatch errors will always happen if there are any cells being checked with the value #N/A I had to learn this the hard way. If you have any cells with that value the code will break each time unless an on error resume next is put in which I rarely encourage.
|
|
| 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 8 
Office 2003
Hybrid Mode