Hi, i am trying to using a Sub to update the value of a cell & then proceed to do something else.
Here's an example of the code piece:
For k = 2 to 10
ActiveSheet.Cells(k,3).Value = 10
Next k
VBA seems to quit after it has changed the value for k = 2. Why is that?
Thanks for your help!
Here's an example of the code piece:
For k = 2 to 10
ActiveSheet.Cells(k,3).Value = 10
Next k
VBA seems to quit after it has changed the value for k = 2. Why is that?
Thanks for your help!