Hi Senectus, On Sat, Jul 22, 2006 at 21:51:28 +0800, Senectus . wrote:
> I've never used excel very much, but I have need of some "calc trickery" > I need calc to look through all the cells and when it finds a cell > with a variable I wish to set, it will then delete that entire row. You may use the Find&Replace dialog, enter the "variable"'s name, click FindAll, which marks all found cells, then goto menu Edit.DeleteCells, check "Delete entire row(s)" and OK. Just be sure to not click into the sheet during these steps as that would remove the found cells' marks. > I believe a "formula" might do it, or maybe a "macro" ? Formulas can't delete rows, a macro could, if that was a frequently repeated task. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
