Help with VBA Autofit Screen View to any screen resolution

[Jalica]

Hi all,

I have some code that allows me to automatically resize an excel spreadsheet to fit on any screen resolution either vertically (by columns) or horizontally (by rows)


Module Code

Please Login or Register  to view this content.

Worksheet Code

Please Login or Register  to view this content.

Is it possible to autofit columns A3:AS3 first then have their column widths locked then autofit rows A6:A46.

The result would be that the spreadsheet would fit onto any computer screen regardless of the screen resolution because it will have been stretched both vertically and horizontally.


I hope this makes sense and hope that someone will be able to help me with this ....

[Keebellah]

I use this Function I wrote to do that

Please Login or Register  to view this content.

In your case I'd run

Please Login or Register  to view this content.

See if it works for you