Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sizing a window to fit a range
Help!
I'm trying to size a window to fit to the width of a selected range. You'd think it'd be possible just to set Window(1).Width=Range("X").Columns.Width, plus or minus some UsableWidth adjustments, or something. But there seem to be some differences between the Window widths, the Application widths, and the range width that I haven't been able to reconcile. Can anybody point me to something explaining the differences among the different Width and UsableWidth properties for Range, Window, and Application? For example, which include the row/column headers, window borders, scroll bars, etc.? Which are affected by font size? Zoom level? There must be a decent source for this. Even better, does anyone have a good, solid routine for sizing a window to the width of a range, given an arbitrary, fixed Zoom level, independent of screen resolution? Thanks once again, -Gary Wolf |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a pop-up window that displays a range in Excel?? | Excel Worksheet Functions | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
self-sizing adv.filter criteria range | Excel Discussion (Misc queries) | |||
Display range of cells in popup window | Excel Programming | |||
Open a window / box showing a selected range of cells only | Excel Programming |