Advertisement
Guest User

Left-20 from Column B to A

a guest
Sep 29th, 2023
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Private Sub Worksheet_Change(ByVal Target As Range)
  2.     If Target.Column = 2 And Target.Row > 1 Then
  3.         Cells(Target.Row, 1).Value = Left(Cells(Target.Row, Target.Column).Value, 20)
  4.     End If
  5. End Sub
  6.  
Tags: excel vba
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement