I would use autofilter on column 30 to hide the rows with zeros.

Print what's left.

Turn on the macro recorder whilst running the operation.


Gord Dibben MS Excel MVP

On Wed, 25 Aug 2010 11:28:19 -0700 (PDT), JingleRock
wrote:

I have a spreadsheet of 1100 rows and 30 columns. In the last column,
I have a formula in each row that evaluates to an integer value
between 0 and 20.

I want by VBA Code to print all rows, with zero blank rows in between,
that have a value in thiis last column greater than zero.

Help.