Ghost Cell Selection
 

I have an odd action occuring in my spreadsheets, When I select a cell,
another cell in a random position also gets selected (seems random).

I must qualify this with the fact that I am running "Worksheet_Change" in
the background. I also perform all kinds of code on this worksheet that
audits various cells for different things and after these occur this odd
action appears. Anyone ever experienced this and know how to resolve?

thank you in advance.

Ghost Cell Selection
 

if you are changing cell values in the change event, then this could be the
problem (as I recall) disable events before you make the change, then
reenable

application.EnableEvents = False
' code in the change event that changes a cell
Application.EnableEvents = True

--
Regards,
Tom Ogilvy


"Bret" wrote in message
...
I have an odd action occuring in my spreadsheets, When I select a cell,
another cell in a random position also gets selected (seems random).

I must qualify this with the fact that I am running "Worksheet_Change" in
the background. I also perform all kinds of code on this worksheet that
audits various cells for different things and after these occur this odd
action appears. Anyone ever experienced this and know how to resolve?

thank you in advance.