Désolé pour mon orthographe ,
mon programme réel, j'utilise :
colonne A correspond au nom de mon connecteur
colonne C correspond a la broche du connecteur
colonne B correspond à le nom d'un bornier
colonne D correspond à a un borne du bornier la terminaison "D" ou "G" n'a aucune importance.
Lorsque j'ai que des connecteurs jarrive a obtenir <>(tc1.a2)(TC2.d3) (par exemple) en utilisant ceci:
[cpp]Sub Calcul()
'
'
Application.ScreenUpdating = False
Columns("A:A").Select
Selection.Insert Shift:=xlToRight
Columns("C:C").Select
Selection.Insert Shift:=xlToRight
Columns("E:E").Select
Selection.Insert Shift:=xlToRight
Columns("G:G").Select
Selection.Insert Shift:=xlToRight
Columns("H:H").Select
ActiveWindow.SmallScroll Down:=-9
Columns("D
").Select
Selection.Cut Destination:=Columns("I:I")
Columns("F:F").Select
Selection.Cut Destination:=Columns("D
")
Columns("I:I").Select
Selection.Cut Destination:=Columns("F:F")
Columns("F:F").Select
Rows("1:1").Select
Selection.Delete Shift:=xlUp
Range("A1").Select
ActiveCell.FormulaR1C1 = "<>("
Selection.AutoFill Destination:=Range("A1:A65536"), Type:=xlFillDefault
Range("A1:A9").Select
Range("C1").Select
ActiveCell.FormulaR1C1 = "."
Selection.AutoFill Destination:=Range("C1:C65536"), Type:=xlFillDefault
Range("C1:C14").Select
Range("E1").Select
ActiveCell.FormulaR1C1 = ")("
Selection.AutoFill Destination:=Range("E1:E65536"), Type:=xlFillDefault
Range("E1:E16").Select
Range("G1").Select
ActiveCell.FormulaR1C1 = "."
Selection.AutoFill Destination:=Range("G1:G65536"), Type:=xlFillDefault
Range("G1:G19").Select
Range("I1").Select
ActiveCell.FormulaR1C1 = ")"
Selection.AutoFill Destination:=Range("I1:I65536"), Type:=xlFillDefault
Range("I1:I22").Select
Columns("A:A").Select
Selection.Insert Shift:=xlToRight
Columns("A:J").Select
Selection.Interior.ColorIndex = 2
Columns("A:J").Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.Weight = xlThick
.ColorIndex = 11
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.Weight = xlThick
.ColorIndex = 11
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlThick
.ColorIndex = 11
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.Weight = xlThick
.ColorIndex = 11
End With
With Selection.Borders(xlInsideHorizontal)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 11
End With
Range("A1").Select
Sheets("Feuil4").Visible = True
Sheets("Feuil4").Select
Dim Lig As Long
Dim Col As String
Dim NbrLig As Long
Dim NumLig As Long
Sheets("Feuil4").Activate ' feuille de destination
Col = "C" ' colonne de la donnée non vide à tester
NumLig = 0
With Sheets("feuil1") ' feuille source
NbrLig = .Cells(65536, Col).End(xlUp).Row
For Lig = 1 To NbrLig
If .Cells(Lig, Col).Value <> "" Then
.Cells(Lig, Col).EntireRow.Copy
NumLig = NumLig + 1
Cells(NumLig, 1).Select
ActiveSheet.Paste
End If
Next
End With
ActiveWindow.DisplayGridlines = False
Columns("B:B").EntireColumn.AutoFit
Columns("C:C").EntireColumn.AutoFit
Columns("D
").EntireColumn.AutoFit
Columns("E:E").EntireColumn.AutoFit
Columns("F:F").ColumnWidth = 10.86
Columns("F:F").EntireColumn.AutoFit
Columns("G:G").EntireColumn.AutoFit
Columns("H:H").EntireColumn.AutoFit
Columns("I:I").EntireColumn.AutoFit
Columns("J:J").EntireColumn.AutoFit
Cells.Select
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.ShrinkToFit = False
.MergeCells = False
End With
Range("A1").Select
Sheets("Feuil1").Select
Sheets("Feuil1").Visible = False
Sheets("Feuil4").Select
Range("G1").Select[/cpp]
Ma question est de savoir comment faire le lien lorsque l'on a un bornier, quelle écriture utiliser ?
merci de ton aide.