Hiding Rows

[Mark]

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

 

[Frank Kabel]

Hi
record a macro while doing this manually

 

[Norman Jones]

Hi Mark,

See Chip Pearson's Delete Blank Rows page at:

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