Thread: Test if CELL is in RANGE
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
  
Posts: 1,688
Default Test if CELL is in RANGE
Kind of long but here it is in one formula:

A1 = cell address to check

=AND(COLUMN(INDIRECT(A1))=COLUMN(range),COLUMN(IN DIRECT(A1))<=COLUMN(range)+COLUMNS(range)-1,ROW(INDIRECT(A1))=ROW(range),ROW(INDIRECT(A1))< =ROW(range)+ROWS(range)-1)

Biff

"Vaughan" wrote in message
...
Is it possible to test if a given cell falls within a range (or more
specifically if it falls within the 'print_area' named range)?


Reply With QuoteReply With Quote