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
Application.CutCopyMode = False
Does anyone have an idea on how I can maybe make this work? Thank you in advance for your time and help!