I guess I mean support HTML as in round tripping. There has always
been some manner of support for creating HTML files which is the
opposite of what you want.

Though it is not what I wanted to add, I have some more information in
Paste / Pasting. Cut & Paste
http://www.mvps.org/dmcritchie/excel/paste.htm

The page I was actually looking for that may be of interest to you is
Delete Cells/Rows in Range, based on empty cells, or cells with specific values
http://www.mvps.org/dmcritchie/excel/delempty.htm
http://www.mvps.org/dmcritchie/excel/code/delempty.txt
I used these a lot with Excel 95 and have used them occasionally
on Excel 2000 and Excel 2002, but pasting into Excel usually worked
fairly decently.