View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad K. Brad K. is offline
external usenet poster
 
Posts: 41
Default How to set multiple columns in "If Target.Column ="

I want to run the same code when one of several columns contain the active
cell. How do I do this without repeating the code.
When I used

If Target.Column = 7 Or 8 Or 9 Or 10 Or 11 Or 12 Or 13 Then

the code is executed when any cell in the sheet is selected not just in the
above columns.
I tried using an array without luck either.
Also, I am not sure yet if all of the columns will be sequential or not.
Thanks in advance for any assistance.
Brad