Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Macro
I would like to be able to click on a cell and a macro would run that would
highlight all cells in the spreadsheet that have the same value as the cell that was just clicked. For example if cell A12 has the value "Bob" then if I left mouse click that cell, all other cells containing the value "Bob" would be highlighted red. If I click on the cell A13 that has the value "jill" then all instences of Bob would be unhighlighted and all cells containing the value Jill would be then highlighted red. I would like this marco function to work for any cell that is clicked in the A12 to A24 range. The search area would be A1:A10. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace and Find & Insert macro help needed | Excel Programming | |||
Get Macro warning, but can't find Macro | Excel Worksheet Functions | |||
change error message when no more for "find" in macro to find | Excel Programming | |||
cant find a macro | Excel Programming | |||
I need to find a macro to find data cut and paste to another colu. | Excel Programming |