Hate-Excel-Need was thinking very hard :
Hi all,

I'm hoping to find a simple way to add page breaks in my template to the
start of each day, to make it more printer friendly.

Originally, I had planned to use =IF(b1b2,"Page",1) command in column D
to determine where I wanted the page breaks to be, then use Go to -
Constants - Text, to add page breaks on each "Page" cell. However, I
only get a page break in the first instance.


Day 1 1737 Data 1
Day 1 1752 Data 1
Day 1 1800 Data 1
Day 1 1827 Data 1
Day 1 1830 Data 1
Day 1 1930 Data 1
Day 1 2030 Data 1
Day 1 2230 Data 1
Day 1 2330 Data 1
Day 2 0000 Data Page
Day 2 0030 Data 1
Day 2 0100 Data 1
Day 2 0200 Data 1
Day 2 0230 Data 1
Day 2 0300 Data 1


I'm hoping someone here knows a simple way to accomplish this,
preferably without resorting to VB scripting, as I am a VB noob.

Have you tried using PageBreak Preview?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion