Re: excel page numbers

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 01/04/05 

Date: Tue, 4 Jan 2005 18:15:36 +0100

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?
>> >>
>> >>
>> >>
>>
>>
>
>