Customizing view

[Jan]

I would like to know is there a way to customize or change
the view of the spreadsheet to fit to the screen
similiarly to the way the print screen looks like?

I know that I can change the percentage but that changes
the overall ratio.

thanks in advance, Jan

 

[Ron de Bruin]

You can use Zoom like this to only see a range

Range("b3:g10").Select
ActiveWindow.Zoom = True