Copy/Paste columns in another sheet with values updates

Hi everyone, I’m also working on how to select specific and multiple columns, I want to paste the value of the column A,B,D into the “EN” sheet, also in ABD columns, but I always have a error message, like this one: that command cannot be used on multiple selections. Here is the code:

 

Private Sub Worksheet_Change(ByVal Target As Range)

Dim Col As Integer

Col = Target.Column

If Col = 1 Or Col = 2 Or Col = 4 Then

Me.Range(“A:B,D:D”).Copy Destination:=Sheets(“EN”).Range(“A:B,D:D”)

Application.CutCopyMode = False

End If

End Sub

 

Does anyone have an idea on how I can maybe make this work? Thank you in advance for your time and help!

By: ayanlun88

Leave a Reply

Your email address will not be published. Required fields are marked *