Does anyone know how to resize the Excel cells to match the screen resolution the user is using. For Example if the user needs to see 5 columns regardless of whether the screen resolution was 768 x 1024 or 600 x 800 how could you resize the columns using VBA.
Fri, 16 Sep 2005 13:49:07 GMT
Colo #2 / 2
Adjust to screen resolution
We can get the screen resolution by API, but I love a simple and easy way. please give it a try.