Customizing view

J

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
 
R

Ron de Bruin

You can use Zoom like this to only see a range

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