Auto update till......
 

Need help with a macro, i need a sheet to auto update till cell I12 says
specific text. Thanks!


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=475989

What do you mean by "auto update"? Tell us what you want to do. HTH Otto
"comotoman" wrote
in message ...

Need help with a macro, i need a sheet to auto update till cell I12 says
specific text. Thanks!


--
comotoman
------------------------------------------------------------------------
comotoman's Profile:
http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=475989

Its with a volatile formula, so i need the sheet to update through a
macro instread of having to press F9 until the cell has certin text
already writtin with other formulas.


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=475989

Comotoman,
is this snippet giving you any ideas?

While Range("myRange") < "mytext"
calculate
Wend

HTH
Kostis Vezerides