Simplification code

[THIERRY35]

Bonjour, question basique mais comment simplifier ce code ??

Merci et bonne soirée

Range("F10:F50").ClearContents
Range("H12:T13").ClearContents
Range("H17:T18").ClearContents
Range("H22:T23").ClearContents
Range("H27:T28").ClearContents
Range("H32:T33").ClearContents
Range("H42:T43").ClearContents
Range("H52:T53").ClearContents

 

[Guest]

Re : Simplification code

Bonsoir,

Range("F10:F50,H12:T13,H17:T18,H22:T23,H22:T23,H32:T33,H42:T43,H52:T53").ClearContents

A+
[Edition] re-Coucou Jean-Marcel😀

 

[THIERRY35]

Re : Simplification code

Bonjour

merci de vos réponses

A +

 

[Staple1600]

Re : Simplification code

Bonsoir à tous


Histoire de simplifier du simplifié 😉

[F10:F50,H12:T13,H17:T18,H22:T23,H27:T28,H32 :T33,H42:T43,H52:T53] = ""