Bonjour,
Un exemple avec une fonction personnalisée.
Cdlt.
Public Sub Test()
MsgBox LastColumn
MsgBox LastColumn(15)
MsgBox LastColumn(, ActiveSheet)
MsgBox LastColumn(8, Worksheets("Feuil1"))
End Sub
Private Function LastColumn(Optional lRow, Optional ws As Worksheet)
If IsMissing(lRow) Then lRow = 1
If ws Is Nothing Then Set ws = ActiveSheet
LastColumn = ws.Cells(lRow, Columns.Count).End(xlToLeft).Column
End Function