I have a 19" monitor an when set to 1600x1200 pixels Excel only displays the
cell range A1:R42 within the window. This is only a portion of the available
window & it appears there is a limit within the programming code

I want to be able to fill the available screen with cells i.e. if A1:AB100
will fit then good.

I am also looking to buy a 30" monitor but there is no point if Excel will
not fill the available window space.