Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Information Positioning Problem
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Information Positioning Problem
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). -----Original Message----- 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink in same sheet - positioning problem | Links and Linking in Excel | |||
What is absolute positioning? | New Users to Excel | |||
Cursor positioning | Excel Discussion (Misc queries) | |||
Odd problem - loosing cell information | Excel Discussion (Misc queries) | |||
msgbox positioning | Excel Programming |