Information Positioning Problem

[Dustin Schofield]

Hi folks:

I was wondering if there is an easy way to position a small block of summary
data (3 rows x 2 col) at the bottom of a worksheet with VBA code. This data
block is set on columns H and I.

My colleagues want to see this summary information block printed at the
bottom of the current page they sit on for quick reference. (page size 8.5
x 11)

I have a strong feeling that the block's vertical position can be
manipulated with code based on the current page's page break location.

Any ideas?

Thank you

Dustin

 

[Rick]

Yes, it's very easy to place summary data in a specific
location on a worksheet. Check out the Cells Method.
I've never thought about changing the location based on
the page breaks, but it could be done since the page
breaks would consistently be in the same position each
time (apart by a constant number of rows).