Question
 

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

Question
 

Range("A1").Select ?

knut
"kirkm" skrev i melding
...
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

Question
 

What is Do stuff doing?

--
Don Guillett
SalesAid Software

"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

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