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.
Bookmarks