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