Worksheet SelectionChange Help

[toobig]

I am using the SelectionChange envent to update a cell to the current date/time when the cell is selected which works great. The problem I am encountering is that when the row is selected with that cell in it, the first cell in that row gets updated (not the cell with the change event). I was wondering if there is a way to keep that from happening. Thanks for the help!!!

 

[Gary McMaster]

Try adding a line like the following as the first line in the event.

If Target.Cells.Count <> 1 Then Exit Sub

HTH,

Gary

 

[toobig]

That worked great!!! Thanks...