Guest User

Untitled

a guest
Feb 24th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.20 KB | None | 0 0
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2. If Intersect(Range("A1"), Target) Is Nothing Then Exit Sub
  3. Sheets(Target.Value).Activate
  4. End Sub
  5.  
  6. Sheets("Data").Range("A1:A1").ClearContents
Add Comment
Please, Sign In to add comment