Posted to microsoft.public.excel.misc

kativa

external usenet poster

Posts: 9

How to insert page break after every 10 rows?

Could anybody help me with the VBA-code needed ub this? I have 3000 rows in
one sheet and I would like to print only 10 rows for each paper.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
insert page break when there is a change in the row value	[email protected]	Excel Worksheet Functions	3	July 14th 06 07:20 PM
cannot insert page break	tsmanz	Excel Discussion (Misc queries)	2	December 5th 05 05:45 PM
Automatically insert page break every 6 rows in excel doc	Icetea	Excel Discussion (Misc queries)	1	October 10th 05 11:55 AM
Insert Page Break Question	Don	Excel Discussion (Misc queries)	1	June 10th 05 02:05 PM
Insert Page Break	Don	Excel Discussion (Misc queries)	3	June 9th 05 08:32 PM

All times are GMT +1. The time now is 08:44 PM.

About Us

"It's about Microsoft Excel"