Thread: Question
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Question

Your code, as written, won't select any particular cell. If the selection is
being changed, then that occurs in the "Do Stuff" code, which you didn't
post. Look in that code for anything with a ".Select" or ".Activate" and
probably delete it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"kirkm" wrote in message
...
After, for example,

If Not Intersect(Target, Range("J1:J20")) Is Nothing Then

Do stuff

End if


... the cell is left selected.

Is there any way to prevent this so the cell is left de-selected ?

If there's not - can someone tell me? Just waiting on this to finish
a project.

Thanks - Kirk