Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not printing hidden cells
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, the nxt 200 will be and the following 10 will be afterthat. what i have noticed is that when the rows are hidden even though they dont print they still appear to have been 'used' in the print preview so if i try and print the document out the first section prints but the bottom 10 ten lines dont print till page 4 (with blank pages before these). What i want is for the bottom section to be printed straight after the top visible rows i.e. by totally ignoring the hidden rows. how can i do this in vba or any other settings? -- sarcher ------------------------------------------------------------------------ sarcher's Profile: http://www.excelforum.com/member.php...o&userid=34457 View this thread: http://www.excelforum.com/showthread...hreadid=542376 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not printing hidden cells
I don't think it's the hidden rows that are causing the trouble. (I've never
seen excel behave that way.) But if you have page breaks in those hidden rows, the page breaks will still be processed. Could that be the problem? My solution is to either remove the page breaks, or to copy the visible cells to a new sheet and print from there--or even take a picture of what I want and print that picture. sarcher wrote: 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, the nxt 200 will be and the following 10 will be afterthat. what i have noticed is that when the rows are hidden even though they dont print they still appear to have been 'used' in the print preview so if i try and print the document out the first section prints but the bottom 10 ten lines dont print till page 4 (with blank pages before these). What i want is for the bottom section to be printed straight after the top visible rows i.e. by totally ignoring the hidden rows. how can i do this in vba or any other settings? -- sarcher ------------------------------------------------------------------------ sarcher's Profile: http://www.excelforum.com/member.php...o&userid=34457 View this thread: http://www.excelforum.com/showthread...hreadid=542376 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count with Hidden cells | Excel Discussion (Misc queries) | |||
paste over hidden cells | Excel Discussion (Misc queries) | |||
Not printing a single cell's value. | Excel Worksheet Functions | |||
hidden cells | Excel Discussion (Misc queries) | |||
Calculating without including Hidden Cells | Excel Discussion (Misc queries) |