| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlighting when a cells contents has changed
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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200706/1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Highlighting when a cells contents has changed
Francoise,
Use this as the first line If Intersect(Target, Range("A1:AJ1")) Is Nothing Then Exit Sub HTH, Bernie MS Excel MVP "Francois via OfficeKB.com" <u18959@uwe wrote in message news:73ee896eed01f@uwe... 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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200706/1 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Highlighting when a cells contents has changed
Bernie Deitrick wrote:
Francoise, Use this as the first line If Intersect(Target, Range("A1:AJ1")) Is Nothing Then Exit Sub HTH, Bernie MS Excel MVP I am using the code below ( thanks to Bob Philips) to indicate which cells have changed since the last update. [quoted text clipped - 3 lines] Thanks for the info Thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200706/1 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Highlighting when a cells contents has changed
Francois wrote:
Francoise, [quoted text clipped - 9 lines] have changed since the last update. [quoted text clipped - 3 lines] Thanks for the info Thanks Indeed that was just what I needed.. -- 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 | |||
| Highlighting when a cells contents has changed | Excel Programming | |||
| Macro to clear range contents when cell contents are changed by us | 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 | |||
Linear Mode
