| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 451 | 1998-11-08 08:55:00 | Excel 97 Print Macro | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 761 | 1998-11-08 08:55:00 | I have a monthly spreadsheet that contains a header, data (entry) and data analysis section. $A$1:$AA$3 is the header, $A$4:$AA$399 is the data entry area, $A$400:$AA$425 is the analysis area (including graphs). The amount a data (rows) varies from month to month with a max permissible of 395 consecutive rows of data. Question is: I'd like macro that prints the worksheet but ignores any blank rows after the last row of data (in the data area), and inserts a page break which puts row 400 at the top of a new page. |
Guest (0) | ||
| 1 | |||||