S
sarcher
Hi,
I have a spreadsheet in which a macro runs and 'hides' any empty rows.
In the spreadsheet it is likely that first 100 rows wont be hidden, th
nxt 200 will be and the following 10 will be afterthat.
what i have noticed is that when the rows are hidden even though the
dont print they still appear to have been 'used' in the print previe
so if i try and print the document out the first section prints but th
bottom 10 ten lines dont print till page 4 (with blank pages befor
these).
What i want is for the bottom section to be printed straight after th
top visible rows i.e. by totally ignoring the hidden rows.
how can i do this in vba or any other settings
I have a spreadsheet in which a macro runs and 'hides' any empty rows.
In the spreadsheet it is likely that first 100 rows wont be hidden, th
nxt 200 will be and the following 10 will be afterthat.
what i have noticed is that when the rows are hidden even though the
dont print they still appear to have been 'used' in the print previe
so if i try and print the document out the first section prints but th
bottom 10 ten lines dont print till page 4 (with blank pages befor
these).
What i want is for the bottom section to be printed straight after th
top visible rows i.e. by totally ignoring the hidden rows.
how can i do this in vba or any other settings