Previous Column

[Terry VanDuzee]

Hello
How do I test the value in the previous column; using Activecell?

In my code, I activate a cell so that I can place a value in it. Using a Do
Until loop, I want to generate a number until the value is greater than the
number in the previous column (same row).

Thank you so much
Terry V

 

[Jim Rech]

Maybe somethin like:

Sub a()
With ActiveCell
While .Value < .Offset(0, -1).Value
.Value = .Value + 10
Wend
End With
End Sub