sub masquer ()
if sheets("variables").range("e8").value=1 then
sheets("lottage").columns("S:CL").visible = false
end if
if sheets("variables").range("e8").value=2 then
sheets("lottage").columns("K:R").visible = false
sheets("lottage").columns("AA:CL").visible = false
end if
end sub()