For t=107 to 126 numero(t-107)=range("L" & str(t)).value next t
for For t=107 to 126 Workbooks("ficher.xls").Sheets("Forms89").Range("R" & str(t) & ":U" & str(t)).Copy Workbooks("2009.xls").Sheets("S89").Select Set cellule = Range("A2:A1000").Find(numero(t-107)) cellule.Select ActiveCell.Offset(0, 6).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks :=True, Transpose:=False next t
DIM Numero(20) For t=107 to 126 numero(t-107)=range("L" & str(t)).value next t for For t=107 to 126 Workbooks("ficher.xls").Sheets("Forms89").Range("R" & str(t) & ":U" & str(t)).Copy Workbooks("2009.xls").Sheets("S89").Select Set cellule = Range("A2:A1000").Find(numero(t-107)) cellule.Select ActiveCell.Offset(0, 6).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks :=True, Transpose:=False next t
For t = 107 To 126 Numero(t - 107) = Range("A1").Cells(t, 12) Next t
Workbooks("ficher.xls").Sheets("Forms89").Range(Cells(t, 18), Cells(t, 21)).Copy
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionWorkbooks("ficher.xls").Sheets("Forms89").Range(Cells(t, 18),, l'erreur d'exécution "9" L'indice n'appartient pas à la selection j'ai essayer de fermer la parenthese mais cela ne change rien.
Workbooks("ficher.xls").Sheets("Forms89").Range(Cells(t, 18), Cells(t, 21)).Copy
Workbooks("ficher.xls").Sheets("Forms89").Activate
For t=107 to 126 Workbooks("ficher.xls").Sheets("Forms89").Activate Workbooks("ficher.xls").Sheets("Forms89").Range("R" & str(t) & ":U" & str(t)).Copy Workbooks("2009.xls").Sheets("S89").Select Set cellule = Range("A2:A1000").Find(numero(t-107)) cellule.Select ActiveCell.Offset(0, 6).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks :=True, Transpose:=False next t
Set cellule = Range("A2:A1000").Find(numero(t-107)) cellule.Select
If range("L110").value=vbnullstring then exit sub