How can I create a macro or code to delete rows? I need it to delete all the
rows with absolutely nothing in them, so basing it on one column won't work.
Also, a lot of the cells are merged throughout.

I am still a little confused about the different drop down choices when
looking at the code area, so if you would please explain what area I would
need to copy to (if you post code). Is it possible to have it where this
macro or code is available whenever I open excel? I do a lot of on-line
reporting in Excel format and it would be a great help to have the macro
available when I first open the reports.

Thanks for your help,

Joel