View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Terry Lowe[_2_] Terry Lowe[_2_] is offline
external usenet poster
 
Posts: 1
Default How to verify a cell is in a named range

I give up. I have been trying to figure this out but I can only get half of
it. I think I need "professional help"!

I have a range name "TimeCells". I need to write an IF statement to verify
that the activecell is within the bounds of the named range. Also I need to
verify that I am on the correct worksheet.

Any help would be greatly appreciated.