getitdaily
MIS
I want to run a command line only if the active cell that is double clicked is in a range.
How do I check the active cell against a range?
How do I check the active cell against a range?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Check activecell against a range
- Thread starter getitdaily
- Start date
- Status
RobBroekhuis
Technical User
You can use
if typename(intersect(activecell,range("A1:A6"
))<>"Nothing" then
...process code here...
end if
(fill in your range as appropriate)
Rob
![[flowerface]](/data/assets/smilies/flowerface.gif "[flowerface] [flowerface]")
if typename(intersect(activecell,range("A1:A6"
))<>"Nothing" then...process code here...
end if
(fill in your range as appropriate)
Rob
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question