Excel 2000 Deleting Empty Cells

I have an Excel 2000 spreadsheet and I want to create a macro that goes through the different pages and deletes rows that have null values. I have no problem sending the speadsheet to anyone that might want to help, so that they understand what I am trying to do. I figured out how to do it in 2007 but I need it in 2000.

Thanks in advance!
Scott

I recorded a macro that I went in and filtered the rage where data could be entered then deleted the empty cells. I unfiltered the data and what I was left with was only cells that had data. For some reason it works in 2007 but gives me an error in 2000.

A macro can certainly be written, but we would need more details. Preferably, post a .zip sample of the workbook with detailed instructions.