Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|