Previous Column

  • Thread starter Thread starter Terry VanDuzee
  • Start date Start date
T

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
 
Maybe somethin like:

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