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" wrote in message
...
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" schrieb im Newsbeitrag
...
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" wrote in message
...
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?