Thread: Test if Cell is within Range (name)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
goepf[_6_] goepf[_6_] is offline
external usenet poster
  
Posts: 1
Default Test if Cell is within Range (name)

I have a dynamic range (meaning the size will change) that is defined
with a name. How can I easily test if an active cell is within that
range?

Thanks,

'expl:

'Range B2:Z15 (name "TESTRANGE")

'ActiveCell D4

'Test if D4 is within "TESTRANGE"


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements
Reply With QuoteReply With Quote