| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 930 | 1999-02-22 11:50:00 | Excel 97 | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1291 | 1999-02-22 11:50:00 | I have a monthly spreadsheet that contains 3 parts - header, data (entry) and data analysis. $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). It would also insert a page break putting row 400 at the top of the next (and last) printed page. |
Guest (0) | ||
| 1 | |||||