View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barry Pettis Barry Pettis is offline
external usenet poster
 
Posts: 4
Default Error with Target.Name.Name in Worksheet_Change event

SuperJas,

If you've named the two ranges, it appears that you have, you
should be able to use the
Range(RNGNAMEHERE).address along with the Target.address to see if user
has made a change in the wrong cell.

I use this method often. The only problem that I have is if the
actual range is merged with other cells. However, it isn't that much of
a problem either.






*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!