mySheet.Activate Range ("A1").Activate While Not ActiveCell.Value = "" TES TRAITEMENTS ActiveCell.Offset(1,0).Activate Wend
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionmySheet.Activate Range ("A1").Activate While Not ActiveCell.Value = "" TES TRAITEMENTS ActiveCell.Offset(1,0).Activate Wend
Sub moyenne() Dim monTab() As Double Dim iCpt, i As Integer iCpt = 0 Range("B1").Activate While Not ActiveCell.Offset(1, 0).Value = "" ReDim Preserve monTab(1, iCpt) monTab(0, iCpt) = ActiveCell.Offset(0, -1).Value monTab(1, iCpt) = (ActiveCell.Value + ActiveCell.Offset(1, 0).Value) / 2 ActiveCell.Offset(0, 2).Value = (ActiveCell.Value + ActiveCell.Offset(1, 0).Value) / 2 ActiveCell.Offset(1, 0).Activate iCpt = iCpt + 1 Wend For i = 0 To iCpt - 1 MsgBox monTab(1, i) Next i End Sub