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

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

daverunt

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

and
 

daverunt

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

Watch MrExcel Video

Forum statistics

Threads
1,118,355
Messages
5,571,693
Members
412,413
Latest member
dvprajapati
Top