Re: excel page numbers

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 01/04/05 

Date: Tue, 4 Jan 2005 13:37:28 -0500

Oops. I guess you (Frank) were commenting on it and not the author. Sorry.

I guess I was not seeing a need to dynamically determine a page number (I
have never been criticised for having too much imagination, however). It is
useful on a fixed layout that will not change - but if it won't change, then
one knows the page number although it might be convenient to have a formula
do it. If the layout will change, then I don't see the need to have a page
number appear at some unknown location on the page - maybe useful for a
filter situation. It wasn't meant to be a criticism in anyway because as I
said, it is very innovative.

My real purpose in posting was to alert the OP that I didn't think it would
solve his problem and save time he might spend thinking it might. Then
again, it might fit somehow. 

-- 
Regards,
Tom Ogilvy
"Frank Kabel" <frank.kabel@freenet.de> wrote in message
news:ujdHDEo8EHA.4004@tk2msftngp13.phx.gbl...
> Hi Tom
> this idea came from Jan Karel :-)
> And I agree with you: Thisn is a nice trick (kind of 'just to prove it is
> possible') but I wouldn't use it in a real-lifre application. But still
neat
> trick and it shows that this kind of feature is somewhat missing in
Excel's
> VBA Object model
>
> -- 
> Regards
> Frank Kabel
> Frankfurt, Germany
> "Tom Ogilvy" <twogilvy@msn.com> schrieb im Newsbeitrag
> news:%23P4rjqn8EHA.3260@TK2MSFTNGP14.phx.gbl...
> > As written, this method would only work for data that would be only one
> > page
> > wide.  Also it won't work for the OP's problem if he uses rows to repeat
> > at
> > the top.  the Page part of "page of" will reflect the page number of the
> > physical location of the formula regardless on what page is being
printed.
> >
> > It would work if the OP did a physical layout, but then he could just
hard
> > code in the page number since it is already known.
> >
> > While a clever idea, I have a hard time seeing where it would actually
> > have
> > any application.  I assume there are some special cases since Frank said
> > he
> > is often asked.
> >
> > -- 
> > Regards,
> > Tom Ogilvy
> >
> >
> >
> > "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message
> > news:O728zWn8EHA.2568@TK2MSFTNGP11.phx.gbl...
> >> See
> >> http://www.dicks-blog.com/archives/2004/12/22/page-of-pages-in-a-cell/
> >>
> >>
> >> -- 
> >> Regards Ron de Bruin
> >> http://www.rondebruin.nl
> >>
> >>
> >>
> >> "Steve J Vaughan" <Steve J Vaughan@discussions.microsoft.com> wrote in
> >> message news:04EA4E23-0635-4247-A573-9D26975AF847@microsoft.com...
> >> > 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 work*** 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" <SteveJVaughan@discussions.microsoft.com> wrote
in
> >> >> message news:AB416BA3-575F-4C76-BD35-C2736217C59E@microsoft.com...
> >> >> > I have been asked to create a spread*** 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?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >
> >
>
>