Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Intersect(Range("A1"), Target) Is Nothing Then Exit Sub
- Sheets(Target.Value).Activate
- End Sub
- Sheets("Data").Range("A1:A1").ClearContents
Add Comment
Please, Sign In to add comment