MAKE CUSTOM VIEW FILL SCREEN

D

Darryl Kramer

Down below is Niek Otten's quick and easy code to make a
NAMED RANGE fill the screen. It works perfectly, thank you
very much Niek.

BUT..... I still can't find a way to make a CUSTOM VIEW to
more or less fill the screen on whichever monitor the view
is shown on, some medium resolution monitors, some high
resolution monitors.

Can someone please help???

darryl@hms or [email protected]


Subject: Re: MAKE NAMED RANGE FILL SCREEN
From: "Niek Otten" <[email protected]> Sent: 2/17/2004
8:25:57 AM

Range("YourName").Select
ActiveWindow.Zoom = True

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top