tablo = Workbooks("toto").Sheets("Feuil1").Range("A1:" & Workbooks("toto").Sheets("feuil1").Cells.SpecialCells(xlCellTypeLastCell).Address)
For i = 1 To UBound(tablo, 2)
Workbooks("titi").Sheets("Feuil2").Range("A1:" & Workbooks("toto").Sheets("Feuil1").Cells.SpecialCells(xlCellTypeLastCell).Address) = tablo
Workbooks("titi").Sheets("Feuil2").Rows(1).SpecialCells(xlCellTypeBlanks).EntireColumn.Delete
Donc ca veut dire que la variable tablo, a la premiere ligne avec les titres, et toutes les bonnes colonnes car on ne garde de la variable tablo que les colonnes qui correspondent aux case.
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionWorkbooks("titi").Sheets("Feuil2").Range("A1:" & Workbooks("toto").Sheets("Feuil1").Cells.SpecialCells(xlCellTypeLastCell).Address) = tablo
Workbooks(file).Sheets(Parametres.FileName).Range("A1:" & Workbooks(file).Sheets(Parametres.FileName).Cells.SpecialCells(xlCellTypeLastCell).Address) = tablo Workbooks(file).Sheets(Parametres.FileName).Rows(1).SpecialCells(xlCellTypeBlanks).EntireColumn.Delete
Workbooks(Parametres.FileName.Text & extension).Sheets(Parametres.FileName.Text).Range("A1:" & Workbooks("Trainingcheck_update2_macro.xlsm").Sheets("training").Cells.SpecialCells(xlCellTypeLastCell).Address) = tablo Workbooks(Parametres.FileName.Text & extension).Sheets(Parametres.FileName.Text).Rows(1).SpecialCells(xlCellTypeBlanks).EntireColumn.Delete
Dim wb As Workbook Dim ws As Worksheet Set wb = Workbooks.Open(file) Set ws = wb.Worksheets(1) Workbooks(Parametres.FileName.Text & extension).Sheets(Parametres.FileName.Text).Range("A1:" & Workbooks("Trainingcheck_update2_macro.xlsm").Sheets("training").Cells.SpecialCells(xlCellTypeLastCell).Address) = tablo Workbooks(Parametres.FileName.Text & extension).Sheets(Parametres.FileName.Text).Rows(1).SpecialCells(xlCellTypeBlanks).EntireColumn.Delete
If Parametres.AffTexte.Value = False Then ActiveWorkbook.SaveAs FileName:=file, FileFormat:=xlCSV ActiveWorkbook.Close End If