Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlighting when a cells contents has changed
Francois wrote:
I am using the code below ( thanks to Bob Philips) to indicate which cells have changed since the last update. Is it possible to modify it so that it will only action on a specific range ie cells A1:AJ1. Thanks Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit Application.EnableEvents = False With Target .Interior.ColorIndex = 38 End With ws_exit: Application.EnableEvents = True End Sub -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200706/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to clear range contents when cell contents are changed by us | Excel Programming | |||
Format Cell Colour if contents are Changed ? | Excel Programming | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
Highlighting contents of cells | Excel Programming | |||
how to detect when cell contents has changed | Excel Programming |