Auto update till......

[comotoman]

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

[Otto Moehrbach]

What do you mean by "auto update"? Tell us what you want to do. HTH Otto
"comotoman" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[comotoman]

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.

[vezerid]

Comotoman,
is this snippet giving you any ideas?

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

HTH
Kostis Vezerides