About Us

Ron de Bruin

See
http://www.dicks-blog.com/archives/2...ges-in-a-cell/

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Steve J Vaughan" <Steve J wrote in
message ...
Thanks Tom, I did think there was not going to be an easy solution. I
guess
someone who is clever with VB may find a way, but I guess it is not a
commonly requested function.

"Tom Ogilvy" wrote:

rows to repeat at the top in the last tab of the page setup dialog will
accomplish most of what you want.

Unfortunately, there is no easy way to use that and put the information
you
want in a cell in that range.

you would either need to create a separate worksheet that lays out the
data
exactly as you want it printed with the 3 rows of information physically
repeated in each "page" with the hardcoded page and pages information
entered in the cell. Or you would have to print each page separately
using
rows to repeat at the top, but before each page printed, entering the
page
and pages information in the cell. In the second case, you would have to
calculate the pages information and you could keep track of the page
information. In the first case, you would of course know this
information.

Then again, someone may have a better approach I am not aware of.

--
Regards,
Tom Ogilvy

"Steve J. Vaughan" wrote in
message ...
I have been asked to create a spreadsheet with the first three rows
repeated
on every page. However in one of the cells in the first three rows
there
is a
requirement for the page number and number of pages . I know this is
normally
set in the page header but the layout requires it in a specfied cell.

Is there away of getting the &[page] and &[pages] data into a cell, and
will
it work when printing?

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can Enter Page Numbers and/or page ranges separated by commas.	d	Excel Discussion (Misc queries)	1	December 3rd 08 03:41 PM
Add page numbers to multiple worksheets without changing page setu	alatona	Excel Discussion (Misc queries)	2	March 16th 07 07:23 PM
Excel page numbers	hanadiv	Excel Discussion (Misc queries)	1	November 21st 05 03:11 PM
How to Add page numbers to a excel spreadsheet?	redhead101863	Charts and Charting in Excel	1	October 23rd 05 01:00 AM
Page Numbers in Excel	Terri D.	Excel Discussion (Misc queries)	3	June 28th 05 07:17 PM

Menu

About Us