If ActiveCell.Column > 1 Then Range(Cells(3, ActiveCell.Column - 1), Cells(67, ActiveCell.Column - 1)).Select End If
Dim srcRang As Range, destRang As Range Set srcRang = Range(Cells(3, ActiveCell.Column - 1), Cells(5, ActiveCell.Column - 1)) Set destRang = Range(Cells(3, ActiveCell.Column - 1), Cells(5, ActiveCell.Column + 1)) srcRang.AutoFill Destination:=destRang, Type:=xlFillDefault destRang.Select
Dim srcRang As Range, destRang As Range Set srcRang = Range(Cells(3, ActiveCell.Column - 1), Cells(67, ActiveCell.Column - 1)) Set destRang = Range(Cells(3, ActiveCell.Column - 1), Cells(67, ActiveCell.Column + 1)) srcRang.AutoFill Destination:=destRang, Type:=xlFillDefault destRang.Select
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSet srcRang = Range(Cells(ActiveCell.Row - 1, "A"), Cells(ActiveCell.Row - 1, "L")) Set destRang = Range(Cells(ActiveCell.Row - 1, "A"), Cells(ActiveCell.Row, "L")) srcRang.AutoFill Destination:=destRang, Type:=xlFillDefault