Guest User

Untitled

a guest
Jun 22nd, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  2. If Not Intersect(Me.Range("Group1"), Target) Is Nothing Then
  3.  
  4. With wksData
  5. .Range("Group1Column").Value = Target.Column
  6. .Range("Group1Row").Value = Target.Row
  7. End With
  8. End If
  9.  
  10. End Sub
Add Comment
Please, Sign In to add comment