Highlight duplicate Rows and filter undu filter and highlight
Posted on 2011-03-22
excel 2003 vba
I need 2 functions to work form 2 command buttons
I have a sheet that will at any given time have any number of rows...
except row1(column headers A1:AU1)
Duplicate values will be in COLUMN Q
The first command button will highlight the rows in yellow., and show only the rows in yellow via a filter.
2nd command will undo filter
I cannot buy an add-in program.