The easiest way its to record a macro and than edit it for future use.
The steps to take for your code:

1. Select a column.
2. Edit Go To Special Blanks
3. Delete Rows

--
sb
"chrismania" wrote in message
...
Hi Guys,

I have the following structure of a table (see attachment).
As you can see some rows are completly empty.
Want I would like to do now is delete these rows if they are empty by
using a macro.

File Attached: http://www.excelforum.com/attachment.php?postid=317210
(example.xls)

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/