Thread
:
Print long sheet shared on pages
View Single Post
#
1
Posted to microsoft.public.excel.programming
pygmalion
external usenet poster
Posts: 2
Print long sheet shared on pages
Hi
I'm struggling with the following problem.
I have an excel sheet that exists of two columns, name and e-mail.
Now, I have to print the entire sheet, but it is about 2500 rows long.
Is there a possibility to let excel print it twice per page?
So, for example:
Instead of printing the following (consider it to be a long list):
Jack Higgins
Peter Jackson
....
....
-- here would be the end of the first printed page
Mike Wilson
Joe Placido k.placido
....
....
-- here would be the end of te second printed page
Excel should be able to print it in the following way:
Jack Higgins
Mike Wilson
Peter Jackson
Joe Placido
..... ....
..... ....
..... ....
I'm a little familiar with programming in excel, but not so much in
implementing
it (with
vb
, for example). If you use such a method, please also
explain
how to implement it.
Thanks a lot in advance
pygmalion
Reply With Quote
pygmalion
View Public Profile
Find all posts by pygmalion