Print variable number of rows of spreadsheet

  • Thread starter Thread starter JingleRock
  • Start date Start date
J

JingleRock

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.
 
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
 
Back
Top