PDA

View Full Version : Excel 97 Print Macro



08-11-1998, 09:55 PM
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.