| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print variable number of rows of spreadsheet
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print variable number of rows of spreadsheet
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable number of copies to print | Excel Programming | |||
| Copying (variable) rows from another spreadsheet | Excel Programming | |||
| set print area for variable number of columns | Excel Programming | |||
| How do I set a macro to print variable number of pages in excel? | Excel Discussion (Misc queries) | |||
| Use row number in spreadsheet as variable in macro | Excel Programming | |||
![JingleRock[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
