+ Reply to Thread
Results 1 to 4 of 4

Responsive Excel Sheet (Fit to screen)

  1. #1
    Registered User
    Join Date
    11-04-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    85

    Responsive Excel Sheet (Fit to screen)

    Hello

    Screens, display and resolution have changed over time... If I open a blank excel worksheet on my DELL Wide screen 21" desktop monitor having a HD resolution of 1920x1080, I see 40 rows 29 columns (AC) but if I do that on my DELL 14" laptop, I see only 25 rows and 17 columns (Q).

    1. Is it possible in vba to find out how many rows and columns are visible on the active worksheet (irrespective of the screen size and set resolution) and put a string "last row" on the last visible row and "last column" on the last visible column? Example, on my desktop A40 should get the value "last row" and AC40 should get the value "last column"
    2. Assuming I have data in the range A1:L20 with default row height and column width, can this be zoomed automatically to fit to complete screen depending on which desktop/laptop/computer used irrespective of it screen resolution?

    The above is for my knowledge.
    I am actually trying to fit the attached excel sheet to full screen no matter which computer it is opened irrespective of the computer resolution. My data is in the range A1:AY46 with all rows modified to height=10 and column width=2. I am looking for a vba code that can decide what zoom level can fit my sheet to full screen.

    Thank you.
    Attached Files Attached Files
    Last edited by freeofcost; 11-14-2014 at 03:50 AM. Reason: added attachment

  2. #2
    Registered User
    Join Date
    11-04-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    85

    Re: Responsive Excel Sheet (Fit to screen)

    Is there a way to detect visible area and zoom to fit accordingly?

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Responsive Excel Sheet (Fit to screen)

    For visible range you can use

    Please Login or Register  to view this content.
    Check the help on ActiveWindow.Zoom for zooming in on a specific range.

    Note that the zoom will maintain the ranges ratio
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    11-04-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    85

    Re: Responsive Excel Sheet (Fit to screen)

    Thank you Andy... your VisibleRange keyword took me to this link http://www.cpearson.com/excel/zoom.htm. Now things would be easier... Thanx again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 10-29-2014, 03:41 AM
  2. Replies: 3
    Last Post: 06-19-2014, 10:41 AM
  3. when I autofill and save excel becomes non responsive
    By caponti33 in forum Excel General
    Replies: 1
    Last Post: 01-15-2010, 05:50 PM
  4. Excel non responsive
    By Ann Vamsi in forum Excel General
    Replies: 3
    Last Post: 03-23-2009, 07:46 AM
  5. [SOLVED] How to fix keys t s h c v non-responsive only in Excel?
    By bareedy in forum Excel General
    Replies: 1
    Last Post: 07-08-2005, 01:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1