Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Column = 2 And Target.Row > 1 Then
- Cells(Target.Row, 1).Value = Left(Cells(Target.Row, Target.Column).Value, 20)
- End If
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement