LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
DRK DRK is offline
external usenet poster
 
Posts: 40
Default Repeating rows at the BOTTOM of the page

The lawyers want me to put text llike this at the bottom of every page. The
number of rows between the top rows to print and the bottom rows to print
will vary (of course). There can be one to many pages to be printed.
Obviously under Page Setup I can specifiy the rows to repeat at the top of
the page. Is there a way to do the same for the bottom of the page?

If I use a macro to define a multiple print range, that second range appears
on the next page.

I've also tried Tom Ogilvy's suggestion of using linked pictures. That's the
best solution yet but I sometimes find the pictures aren't always updated.
Any way to force a refresh of the picture?

Any chance Excel will ever have Rows to Repeat At Bottom?

Any ideas or solutions would be appreciated.

NOTES:
(1) Any values shown which are based on the life insurance policy are not
guaranteed. The values are based on the current crediting rate and current
policy charges. Actual policy values will be more or less favorable than
those shown. Please refer to the basic ledger for policy guarantees and other
important information. This is a supplemental illustration and is not valid
unless accompanied by the basic ledger illustration.
(2) Any side fund values included in this column are based on a crediting
rate of XX% after tax. This rate is illustrative only and is not
guaranteed.


--
DRK
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Keeping bottom rows on page one Davejp Excel Discussion (Misc queries) 1 October 6th 08 06:34 PM
How can I print repeating rows on every page when printing? mamallama Excel Discussion (Misc queries) 3 March 9th 06 12:24 AM
Repeating rows on new page MissElaineous Excel Discussion (Misc queries) 1 July 22nd 05 09:08 PM
Repeating Rows and Columns on every page BruceM Setting up and Configuration of Excel 0 July 7th 05 09:18 AM
Repeating Rows and Columns on each page of print out BruceM Excel Discussion (Misc queries) 1 July 6th 05 12:28 PM


All times are GMT +1. The time now is 01:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"