determine if cell address is within a range of cells
Try
dim rng_cells as Range
set rng_cells= range("A16:C40")
set int=Intersect(ActiveCell,rng_cells) '
if not int is nothing then ...
"SteelDetailer" wrote in message
...
It's late and I'm hitting a wall.
I need to determine if the activecell is within a range of cells. I've
tried:
if activecell.address = range("A16:C40") then....
but I get a type mismatch. I'm can't find what I'm looking for in the VBA
help, but I'm probably not asking the right question.
Will someone help a novice, please???
TIA,
Rich
|