Tom, Ron and Frank thanks to you all for looking into this for me.

"Frank Kabel" wrote:

Hi Tom
yeah, after I pressed the Send button I saw his post :-)
And I agree with you: dealing with pagebreaks in VBA is not easy (so I
usually stay away from that)

--
Regards
Frank Kabel
Frankfurt, Germany
"Tom Ogilvy" schrieb im Newsbeitrag
...
And only the OP will know :-)
Maybe he posts back!


He did

That does what I need but . . .

A little VB
is not a problem as long as it is not too heavy.

Last time I checked, working with pagebreaks in VB is very heavy.

--
Regards,
Tom Ogilvy




"Frank Kabel" wrote in message
...
Hi Tom
Oops. I guess you (Frank) were commenting on it and not the author.
Sorry.
no need for beeing sorry. Just didn't want to steal JKP this innovation
<vbg


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.

Also didn't considered your initial posting as criticism!.
Though a little bit OT: I think Excel's current features for customized
headers/footers are just poor. For dynamic headers you need VBA. And if
you
want to resort to headers directly on your sheet you have problems
getting
the page numbering information.
On the other hand maybe if you have this kind of reporting requirements
one
should not use Excel anyway :-)


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.

And only the OP will know :-)
Maybe he posts back!

Regards
Frank Kabel