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]
