View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carlos[_6_] Carlos[_6_] is offline
external usenet poster
 
Posts: 14
Default 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