| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SelectionChange works only when Cellpointer is within a given rang
Hi,
I only want the SelectionChange event to run if the Cellpointer is within the range B5:G11, or probaby better referring to B5:G11 as a Range name EG If Target.Address is within the range B5:G11 then run the SelectionChange event! Hope that makes sense to someone. Thanks John |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SelectionChange works only when Cellpointer is within a given rang
You can use the intersect method something like this...
if not intersect(target, Range("B5:G11")) is nothing then msgbox "Bombs Away..." end if -- HTH... Jim Thomlinson "John" wrote: Hi, I only want the SelectionChange event to run if the Cellpointer is within the range B5:G11, or probaby better referring to B5:G11 as a Range name EG If Target.Address is within the range B5:G11 then run the SelectionChange event! Hope that makes sense to someone. Thanks John |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SelectionChange works only when Cellpointer is within a given
Cool, thanks Jim.
"Jim Thomlinson" wrote: You can use the intersect method something like this... if not intersect(target, Range("B5:G11")) is nothing then msgbox "Bombs Away..." end if -- HTH... Jim Thomlinson "John" wrote: Hi, I only want the SelectionChange event to run if the Cellpointer is within the range B5:G11, or probaby better referring to B5:G11 as a Range name EG If Target.Address is within the range B5:G11 then run the SelectionChange event! Hope that makes sense to someone. Thanks John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change cellpointer | Excel Discussion (Misc queries) | |||
| Returning the position of the Cellpointer in the range | Excel Programming | |||
| Is there a quicker way to copy a rang abd its formatting this is 2 | Excel Discussion (Misc queries) | |||
| Macro Sum Formula For a Variable Rang | Excel Programming | |||
| Count Rang of Filled-In Cells | Excel Worksheet Functions | |||
Hybrid Mode
