<div>
Great answer. Thanks very much
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
I use the following code to highlight cells when values are changed. I also highlight<br />
the last cell in that row to show that it has been changed<br />
It works fine for one cell but when I copy the changed value<br />
down with the mouse the cell that changes changes color but<br />
the cell at the end of the row doesn't change color<br />
<br />
Private Sub Worksheet_Change(ByVal Target As Range)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Application.Cells(Target.R<wbr />ow, Target.Column).Interior.Co<wbr />lor = 65535<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Application.Cells(Target.R<wbr />ow, 16384).Interior.Color = 65535<br />
End Sub
</div>
</div>


Hi
I use the following code to highlight cells when values are changed. I also highlight
the last cell in that row to show that it has been changed
It works fine for one cell but when I copy the changed value
down with the mouse the cell that changes changes color but
the cell at the end of the row doesn't change color

Private Sub Worksheet_Change(ByVal Target As Range)
                    Application.Cells(Target.Row, Target.Column).Interior.Color = 65535
                    Application.Cells(Target.Row, 16384).Interior.Color = 65535
End Sub

Excel VBA Highlighting cells on sheet change

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.