View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SteelDetailer[_2_] SteelDetailer[_2_] is offline
external usenet poster
 
Posts: 13
Default determine if cell address is within a range of cells

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