Home |
Search |
Today's Posts |
#5
![]() |
|||
|
|||
![]()
How about Tools | Goal Seek... ?
Set the lower cell A1 to increase to the value of B1 by changing C1. This will set A1 & B1 equal. As a macro... Range("A1").GoalSeek Goal:=Range("B1").Value, ChangingCell:=Range("C1") HTH -- Dana DeLouis Win XP & Office 2003 "goodpasture" wrote in message ... It really doesn't matter, I just want this cell to increment and while incrementing, it checks the value of another cell until it is not less than another cell. While B1 A1 C1 = C1 + .001 END Please Help!!! -- goodpasture ------------------------------------------------------------------------ goodpasture's Profile: http://www.excelforum.com/member.php...o&userid=23898 View this thread: http://www.excelforum.com/showthread...hreadid=393906 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |