I have a spreadsheet with several pages, on last page have rows with
formula's reading data from previous pages. Data could be 0 or greater.

Is there a way of compressing rows(useing macro or other means) to only
see rows with value 1 & above.
At the moment i have row with data, 2 blank rows (with formula) then
row with data then blank etc etc. Depending on data entered on first
pages the results on last page can be different every time, the blank
rows with formula's can be in a different position. I only want to
print rows with data. It needs to print in the order on the page. I
have recorded a macro which deletes blank rows but it leaves ones with
formulas in..even if result value is zero. Is there anywhey of getting
rid of these..


--
Stuart Arnold
------------------------------------------------------------------------
Stuart Arnold's Profile: http://www.excelforum.com/member.php...o&userid=30102
View this thread: http://www.excelforum.com/showthread...hreadid=497913

Can't you use auto filter and use a custom filter of greater than 0


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=497913