ARUNCHENNAI
Board Regular
- Joined
- Apr 24, 2017
- Messages
- 66
Hi,
I want the desired result in Z column though VBA
<tbody>
</tbody>
My code is not working. Kindly help.
I want the desired result in Z column though VBA
X | Y | Z |
Plan | Actual | Desired Result |
10 | 10 | 10 |
0 | 20 | 0 |
20 | 30 | 20 |
30 | 40 | 30 |
0 | 50 | 0 |
40 | 40 | |
0 | 0 | |
50 | 50 | |
60 | 0 | |
0 | 0 | |
0 | 0 | |
0 | 0 | |
70 | 0 | |
80 | 0 | |
90 | 0 | |
0 | 0 |
<tbody>
</tbody>
My code is not working. Kindly help.
Code:
Sub test()Dim X As Range, Y As Range, Z As Range
For Each X In Range("A5:A20")
For Each Y In Range("B5:B20")
For Each Z In Range("C5:C20")
If X = 0 Then
Z = 0
'End If
Else
If X <> 0 Then
Z = X.Value
End If
End If
Next Z
Next Y
Next X
End Sub