View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Brad is offline
external usenet poster
 
Posts: 57
Default Multiple Target Addresses...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$6" Then
Run "Run_Print1"
ElseIf Target.Address = "$A$7" Then
Run "Run_Macro1"
End If
End Sub

Well, the above code works well but I need to have the two macros it runs
depending on the cell selected, be activated by a few more cell selections
in each case. So, where I now only have cell selection A6, I also need to
have A47, A88, A129, A170, and A211 selected cells activate the
'"Run_Print1"' sequence. And, in addition to A7, I need A48, A89, A130,
A171, and A212 for the 'Run_Macro1"' sequence to fire off.

My thanks in advance for any ideas how best to tackle expanding the
selections for Target.Address

Brad