Hi Mark,

See Chip Pearson's Delete Blank Rows page at:

http://www.cpearson.com/excel/deleting.htm


---
Regards,
Norman



"Mark" wrote in message
om...
I am trying to create a macro that will hide(suppress) blank rows on a
report. Can somebody help me with this?