MAKE NAMED RANGE FILL SCREEN

  • Thread starter Thread starter Darryl Kramer
  • Start date Start date
D

Darryl Kramer

Can someone PLEEEEZE help. I am trying to make a NAMED
RANGE or alternatively a CUSTOM VIEW fill the screen no
matter which computer it is used on. What works fine on
low resolution screens only fills a small part of the
screen on lucky users with high res screens. I can't
change the display settings of individual users but surely
a macro could be crafted to ZOOM to make the desired cells
fill whatever screen they are shown on????
Help ! Please ! (from (e-mail address removed))
 
Range("YourName").Select
ActiveWindow.Zoom = True

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Back
Top