Can i make the excel sheet zoom in /out so it always shows range A1 to T35?

[tonywatsonhelp]

Hi Everyone,
I'd like a macro that can make the activesheet zoom in or out on any screen to show the range A1 to T35, now I realise that some screens might be able to show 50rows if its shows coulmns A to T, thats fine so I suppose we get it to zoom to alway show columns A to T then check if row 35 is visable, if not zoom so it is?
hope that makes sense and please help if you can as i'm stuck?

Thanks
Tony

 

[Georgiboy]

You can play with something like below, how you fire the code would depend on your needs. The gist of it is to select the range and then use ActiveWindow.Zoom:

Private Sub Worksheet_Activate()
    Range("A1:T35").Select
    ActiveWindow.Zoom = True
End Sub

 

[tonywatsonhelp]

Thank you, i'll have a play and see what results i get looks like it should be what i need
Thanks
Tony