Need help with a macro, i need a sheet to auto update till cell I12 say specific text. Thanks
C comotoman Oct 13, 2005 #1 Need help with a macro, i need a sheet to auto update till cell I12 say specific text. Thanks
O Otto Moehrbach Oct 13, 2005 #2 What do you mean by "auto update"? Tell us what you want to do. HTH Otto
C comotoman Oct 14, 2005 #3 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.
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.
V vezerid Oct 14, 2005 #4 Comotoman, is this snippet giving you any ideas? While Range("myRange") <> "mytext" calculate Wend HTH Kostis Vezerides
Comotoman, is this snippet giving you any ideas? While Range("myRange") <> "mytext" calculate Wend HTH Kostis Vezerides