Removing data

**Racer53** · 05-08-2012, 09:49 PM

I have a large spreadsheet of 100000 rows and need to remove some rows which contain zeros or no data at all

Does anyone know how to go about this?

Thanks

**vlady** · 05-08-2012, 10:16 PM

this will delete empty rows
macro

Please Login or Register  to view this content.

**shg** · 05-08-2012, 10:19 PM

That will actually delete empty cells, vlady, which will seriously hose a record-oriented database.

In addition, SpecialCells is limited to returning 8192 areas, and fails spectacularly by returning the entire range if there are more than that.

**vlady** · 05-08-2012, 10:31 PM

yes, i just assumed that entire row is empty..

otherwise this is not advisable for him.

**Winon** · 05-08-2012, 10:32 PM

@ vlady & shg,

I agree with shg. This is not as simple as it sounds, as a lot of factors come into play before one just start deleting.

Perhaps, if Racer53 could upload a sample workbook of exactly what such sheet/s may contain, one could come up with a solution.