How to size Excel's window to fit spreadsheet data
 

Greetings,
Say you have a rectangular "block" of cells 10 columns wide and 10
columns tall,
Q. How do you [programmatically] make Excel's window (the application
window) exactly the right size to show the "block"?

Thanks/Cheers!
--
The Cobra: A few Cobras in your home will soon clear it of Rats and Mice. Of
course, you will still have the Cobras. (a quote by Will Cuppy
http://en.wikiquote.org/wiki/Will_Cuppy)

Apologies for double-post!..
 

Apologies for double-post!
Didn't see first post show-up - was using my own username in search-criteria.

"tbd" wrote:

Greetings,
Say you have a rectangular "block" of cells 10 columns wide and 10
columns tall,
Q. How do you [programmatically] make Excel's window (the application
window) exactly the right size to show the "block"?

Thanks/Cheers!
--
The Cobra: A few Cobras in your home will soon clear it of Rats and Mice. Of
course, you will still have the Cobras. (a quote by Will Cuppy
http://en.wikiquote.org/wiki/Will_Cuppy)

How to size Excel's window to fit spreadsheet data
 

See your earlier post

Regards,
Peter T

"tbd" wrote in message
...
Greetings,
Say you have a rectangular "block" of cells 10 columns wide and 10
columns tall,
Q. How do you [programmatically] make Excel's window (the application
window) exactly the right size to show the "block"?

Thanks/Cheers!
--
The Cobra: A few Cobras in your home will soon clear it of Rats and Mice.
Of
course, you will still have the Cobras. (a quote by Will Cuppy
http://en.wikiquote.org/wiki/Will_Cuppy)