Russell King 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
No time to elaborate, but if speed is an issue, you might consider using
the getDataArray() method for a cell range and then traversing the data,
it is likely to be faster...
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
