1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| Sub essai()
Dim LR As ListRow, Tableau As ListObject, LRIndex As Integer
Dim i As Long
Set Tableau = Sheets(1).ListObjects(1)
Sheets(1).Protect UserInterfaceOnly:=True, _
DrawingObjects:=True, _
Contents:=True, _
Scenarios:=True, _
AllowFormattingCells:=False, _
AllowFormattingColumns:=False, _
AllowFormattingRows:=False, _
AllowInsertingColumns:=False, _
AllowInsertingHyperlinks:=False, _
AllowDeletingColumns:=False, _
AllowSorting:=False, _
AllowFiltering:=False, _
AllowUsingPivotTables:=False, _
AllowDeletingRows:=False, _
AllowInsertingRows:=False
If Not Tableau.DataBodyRange Is Nothing Then Tableau.DataBodyRange.Delete
For i = 1 To 5
Set LR = Tableau.ListRows.Add
If Tableau.DataBodyRange Is Nothing Then
Sheets(1).Cells(Tableau.HeaderRowRange.Row + 1, Tableau.ListColumns(1).Range.Column) = 0
Else
Sheets(1).Cells(Tableau.HeaderRowRange.Row + Tableau.DataBodyRange.Rows.Count + 1, Tableau.ListColumns(1).Range.Column) = 0
End If
LRIndex = LR.Index
Debug.Print "LRIndex = " & LRIndex
' Je remplis ma ligne
Tableau.ListColumns(1).DataBodyRange.Cells(LRIndex, 1) = LRIndex
Tableau.ListColumns(2).DataBodyRange.Cells(LRIndex, 1) = Chr(Asc("A") + LRIndex - 1)
Next i
End Sub |
Partager