View Single Post
  #5   Report Post  
Dana DeLouis
 
Posts: n/a
Default

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