Probleme de syntaxe

Bonjour,

comment écrire correctement ceci

Range("A6:A" & myvar &" ,C6:C" & myvar ",E6:E "& myvar ").Select

Merci

Bonjour

Un exemple

Sub test()
Dim MyVar As Long

  MyVar = 14
  Range("A6:A" & MyVar & " ,C6:C" & MyVar & ",E6:E" & MyVar).Select
End Sub