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