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

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

Thanks

--
Message posted from http://www.ExcelForum.com