View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dhstein dhstein is offline
external usenet poster
 
Posts: 266
Default Compare address to a range

I have this code in an event macro:

If Target.Address = "$BC$3" Or Target.Address = "$BC$4" Or Target.Address =
"$BC$5" Or Target.Address = "$BC$6" Or Target.Address = "$BC$7" Then


Is there a more compact way to write that statement? Thanks for any help on
this.