Re : Supprimer colonnes
Bonsoir SandraSSQ
Voici un bout de code :
Sub Macro1()
'
' Macro1 Macro
'
Dim Vu As Worksheet
Dim Liste As Worksheet
Set Vu = Worksheets("VU")
Set Liste = Worksheets("Liste")
' Derniere cellule non vide de la ligne (VU = Ligne 1)
finvu = Vu.Range("XFD1").End(xlToLeft).Column
finliste = Liste.Range("A65536").End(xlUp).Row
For i = 1 To finliste
For j = 1 To finvu
If Liste.Cells(i, 1) = Vu.Cells(1, j) Then
'MsgBox Left(Columns(Vu.Cells(1, j).Column).Address, InStr(Columns(Vu.Cells(1, j).Column).Address, ":") - 1) & 1
'Vu.Cells(1, j).Column
Range(Left(Columns(Vu.Cells(1, j).Column).Address, InStr(Columns(Vu.Cells(1, j).Column).Address, ":") - 1) & 1).Select
Selection.EntireColumn.Delete
End If
Next j
Next i
End Sub
laurent