if not intersect (Activecell,[b4:c11]) is nothing then
msgbox "gotcha!"
endif

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"del" wrote:

how do you check if a cell falls under a a range of
cells. in other words, check if a cell is within a
particular range.
i tried using strcomp on the addresses but it didn't work.