need macro to total row heights .. or...

[nooobody]

I'm putting together an application that outputs to excel from access, in
which I insert a variable number of rows on a few sheets, using VBA I need
to put a line of text at the bottom of each sheet, in the same position on
each page. I am using a template for this, and of course I have to
compensate for the added rows(dynamically) and also for the fact that the
template is formatted with different row heights(statically). a macro to
total row heights of a selection would be a good start, to help with
manually doing the static formatting,
but I also need suggestions on how to deal with the effect of adding rows on
the position of the line of text that goes at the end of each sheet Any
advice appreciated.

 

[Tom Ogilvy]

you would have to find the pagebreaks and use that to place your line of
text.

 

[nooobody]

you would have to find the pagebreaks and use that to place your line of
text.

Thanks Tom, I'l check that out