Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Previous Column
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Previous Column
Maybe somethin like:
Sub a() With ActiveCell While .Value < .Offset(0, -1).Value .Value = .Value + 10 Wend End With End Sub -- Jim Rech Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep a previous year when entering down a column | Excel Discussion (Misc queries) | |||
repeat entry from previous column | Excel Worksheet Functions | |||
Based on data in previous column - sum of values in next column | Excel Worksheet Functions | |||
Shortcut to select column with data in previous column | Excel Discussion (Misc queries) | |||
vlookup value from previous column | Excel Discussion (Misc queries) |