Russell, My data input wizard includes some code that deletes rows and shifts remaining data up. You might be able to reuse some of it. In fact - there may be other code in there that may be useful to you.
http://www.openofficetips.com/blog/archives/2005/10/updated_data_en.html Dave On 11/29/05, Russell King <[EMAIL PROTECTED]> wrote: > Hi, > > I am trying to build a macro that will build a synopsis sheet from the > other sheets in a spreadsheet. The synopsis is over 1600 rows long, so > it is a bit tedious to do it by hand and since each sheet changes not > just the data, but the amount of data, the macro ends up putting in a > lot of references to cells that are empty in order to make sure it gets > it all. The macro then sorts the data which leaves over 600 rows of > zeros at the top. What I need is a function for my macro that will go > through the top of the sheet, leaving the header row alone, and delete > the rows that have a value (not content) of zero. > > I have tried various code examples (ie, getCellByPosition), but it > doesn't work (unexpected syntax errors) > > All I want to do is dump the value of a cell (ie $A$2) into a string > variable so that I can compare it. Why does it have to be so hard? > > rk > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- My OpenOffice Calc Website http://www.openofficetips.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
