Making a worksheet fit to the screen

scotthannaford1973

Board Regular
Joined
Sep 27, 2017
Messages
60
Office Version
  1. 2010
Platform
  1. Windows
Hi

okay - I have a worksheet that acts as a landing page to a huge workbook and I'd like it so that the pretty area of the worksheet (lets say A1:Q29) automatically fits to the size of the screen. The problem there is that some people use laptops and some desktops - so the resolution and screensizes are different for everyone.

Is there a VBA way to state that this worksheet range, when the sheet opens, defaults to the height of the viewable area? or similar?

TIA
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

daverunt

Well-known Member
Joined
Jul 9, 2009
Messages
1,868
Office Version
  1. 2013
Platform
  1. Windows
Any use

and
 

daverunt

Well-known Member
Joined
Jul 9, 2009
Messages
1,868
Office Version
  1. 2013
Platform
  1. Windows
Gives me something to do though.
Cheers.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,656
Messages
5,573,428
Members
412,529
Latest member
cTatch
Top