samisamih
04-02-2015, 04:44 AM
I try to create index(n) so that whenever the value of cell A1 is different from the value of cell B1, it is added to the variable N one
The code I wrote:
public n as integer
Private Sub Worksheet_Change (ByVal Target As Range)
If Cells (1, 1) .Value <> Cells (1, 2) .Value Then
Cells (1, 2) .Value = Cells (1, 1) .Value
n = n + 1
End If
Cells (n, 3) .Value = 10
End Sub
But the problem that the variable (n) gets the value in delay, and the macro runs the last command "Cells (n, 3) .Value = 10" before the variable (n) enough to get the value then i get the error because the variable (N) is still zero, how can I solve this issue ?
when I wrote the last command "Cells (n, 3) .Value = 10" within the Conditional the macro works fine,without delay and the variable (n) get the result withount any delay:
public n as integer
Private Sub Worksheet_Change (ByVal Target As Range)
If Cells (1, 1) .Value <> Cells (1, 2) .Value Then
Cells (1, 2) .Value = Cells (1, 1) .Value
n = n + 1
Cells (n, 3) .Value = 10
End If
End Sub
but I need to use the variable (n) Outside the Conditional, any help please?
best reagards
The code I wrote:
public n as integer
Private Sub Worksheet_Change (ByVal Target As Range)
If Cells (1, 1) .Value <> Cells (1, 2) .Value Then
Cells (1, 2) .Value = Cells (1, 1) .Value
n = n + 1
End If
Cells (n, 3) .Value = 10
End Sub
But the problem that the variable (n) gets the value in delay, and the macro runs the last command "Cells (n, 3) .Value = 10" before the variable (n) enough to get the value then i get the error because the variable (N) is still zero, how can I solve this issue ?
when I wrote the last command "Cells (n, 3) .Value = 10" within the Conditional the macro works fine,without delay and the variable (n) get the result withount any delay:
public n as integer
Private Sub Worksheet_Change (ByVal Target As Range)
If Cells (1, 1) .Value <> Cells (1, 2) .Value Then
Cells (1, 2) .Value = Cells (1, 1) .Value
n = n + 1
Cells (n, 3) .Value = 10
End If
End Sub
but I need to use the variable (n) Outside the Conditional, any help please?
best reagards