A voir également:
- VBA problme macros :s
- Excel compter cellule couleur sans vba - Guide
- Mkdir vba ✓ - Forum VB / VBA
- Incompatibilité de type vba ✓ - Forum VB / VBA
- Erreur 13 incompatibilité de type VBA excel ✓ - Forum Excel
- Vba range avec variable ✓ - Forum VB / VBA
1 réponse
voila ma macro remis a jour ^^
Sub importbcle()
Dim adrdepvert, adrarrvert, adrdephoriz, adrarrhoriz As Variant
adrarrvert = 5
Dim finrangevert As Integer
finrangevert = 12
Dim b As Integer
b = 2
For k = adrarrvert To 32 Step 9
Sheets("Feuil2").Select
Range(Cells(k, 4), Cells(k + 7, 4)).Select
Selection.Copy
For j = b To 5
Sheets("Feuil1").Select
Cells(2, j).Select
ActiveSheet.Paste
Next j
Next k
End Sub
Sub importbcle()
Dim adrdepvert, adrarrvert, adrdephoriz, adrarrhoriz As Variant
adrarrvert = 5
Dim finrangevert As Integer
finrangevert = 12
Dim b As Integer
b = 2
For k = adrarrvert To 32 Step 9
Sheets("Feuil2").Select
Range(Cells(k, 4), Cells(k + 7, 4)).Select
Selection.Copy
For j = b To 5
Sheets("Feuil1").Select
Cells(2, j).Select
ActiveSheet.Paste
Next j
Next k
End Sub