Am doua coloane A si B, randurile din cele doua coloane sunt variabile de asemenea si valorile acestora.
Cod: Selectaţi tot
+---+---+
| A | B |
+---+---+
| 2 | 4 |
| 5 | 6 |
| | 2 |
| | 8 |
+---+---+
2/4
2/6
2/2
2/8
5/4
....
?
Multumesc!
Cod: Selectaţi tot
+---+---+
| A | B |
+---+---+
| 2 | 4 |
| 5 | 6 |
| | 2 |
| | 8 |
+---+---+
Cod: Selectaţi tot
Sub Impartire()
'IPP - 13.06.2018
Application.ScreenUpdating = False
Application.Calculation = xlCalculationAutomatic
Sheets("Sheet1").Select
Range("C2:C1000000").ClearContents
For Each c In Range("A2:A" & Range("A1000000").End(xlUp).Row)
For Each d In Range("B2:B" & Range("B1000000").End(xlUp).Row)
With Range("C1000000").End(xlUp).Offset(1, 0)
.Value = c / d
End With
Next d
Next c
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub
Centrul de training si consultanta IT Learning activeaza de peste 15 ani pe piata serviciilor de instruire si certificare IT din Romania. |
Link-uri utile |
Categorii de cursuri |
Contact |
© 2019 IT Learning Business Intelligence School - Citeste termeni si conditii |