1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
|
for Y = 1 to 4
If y = 1 Then Sheets("1").Select
If y = 2 Then Sheets("2").Select
If y = 3 Then Sheets("3").Select
If y = 4 Then Sheets("4").Select
for i = 1 to nbligne
'6 info de ce genre
Cells(i, 27) = "=if('\\Fiche Verification Materiel\" & Cells(i, 3).Value & "\" & Cells(i, 1).Value & "\" & "[FICHE_INCIDENT_" & Cells(i, 1).Value & ".XLS" & "]Feuil1'!R22C8=0,"" "",'\\Fiche Verification Materiel\" & Cells(i, 3).Value & "\" & Cells(i, 1).Value & "\" & "[FICHE_INCIDENT_" & Cells(i, 1).Value & ".XLS" & "]Feuil1'!R22C8)"
next i
next y |