Dim lRangeSrc as Range Dim lRangeDst as range Set lRangeSrc=Range("A1") Set lRangeDst=Range("A1") Do Until IsEmpty(lRangeSrv.value) lRangeDst.value=lRangeSrv.value Set lRangeSrc=lRangeSrc.Offset(1,0) Set lRangeDst=lRangeDst.Offset(1,0) Loop
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim lRangeSrc as Range Dim lRangeDst as range Set lRangeSrc=sheets("FeuilleSource").Range("A1") Set lRangeDst=sheets("FeuilleDestination")Range("A1") Do Until IsEmpty(lRangeDst.value) Set lRangeDst=lRangeDst.Offset(1,0) Loop Do Until IsEmpty(lRangeSrv.value) lRangeDst.value=lRangeSrv.value Set lRangeSrc=lRangeSrc.Offset(1,0) Set lRangeDst=lRangeDst.Offset(1,0) Loop
Dim lRangeSrc As Range Dim lRangeDst As Range Set lRangeSrc = Sheets("Feuil1").Range("A1") Set lRangeDst = Sheets("Feuil2").Range("A1") Do Until IsEmpty(lRangeDst.Value) Set lRangeDst = lRangeDst.Offset(1, 0) Loop Do Until IsEmpty(lRangeSrc.Value) lRangeDst.Value = lRangeSrc.Value Set lRangeSrc = lRangeSrc.Offset(1, 0) Set lRangeDst = lRangeDst.Offset(1, 0) Loop
Dim lRangeSrc As Range Dim lRangeDst As Range Set lRangeSrc = Sheets("Feuil1").Range("A1") Set lRangeDst = Sheets("Feuil2").Range("A1") Do Until IsEmpty(lRangeDst.Value) Set lRangeDst = lRangeDst.Offset(1, 0) Loop Do Until IsEmpty(lRangeSrc.Value) lRangeDst.Value = lRangeSrc.Value Set lRangeSrc = lRangeSrc.Offset(1, 0) Set lRangeDst = lRangeDst.Offset(1, 0) Loop