View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ppsza[_6_] ppsza[_6_] is offline
external usenet poster
 
Posts: 2
Default What range is a cell in?

Concerning Excel VBA: Does anyone know of a way that I can find ou
what range a particular cell (ActiveCell) is in? Here's th
situation: I have several named ranges in a worksheet. When a cel
changes, if it is in a particular range, then some code needs to b
executed, and, if it's in another range, other code needs to b
executed

Thanks