by Ferru123 » Sun Feb 18, 2018 8:39 pm
I have a macro that copies the value 1 from cells in the EK column to the adjacent cell in the EL column:
Dim b As Integer
For b = 5 To 35
If Range("EK" & b).Value = 1 Then Range("EL" & b).Value = 1
Next b
When I enter a new market, I clear the column through the command Range("EL5:EL35").Value = "".
The challenge I have is that, when the value of (say) EK5 ceases to be 1, then the value of EL5 changes too.
I don't understand this. Can anyone help please?
Thanks
Jeff