Option Explicit
Private Sub CommandButton1_Click()
Worksheets("Feuil2").UsedRange.ClearContents 'On effaca le contenu
getRange("ALU", 11).Copy Destination:=Worksheets("Feuil2").Range("A1")
End Sub
Function getRange(name As String, nbCol As Long) As Range
Dim derLigne As Range
Set getRange = Range(name).Resize(1, 1)
Set derLigne = getRange.End(xlDown)
Set getRange = getRange.Resize(derLigne.Row - getRange.Row + 1, nbCol)
End Function