Please see the attached file and the below code:
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
ActiveWindow.Zoom = True: ActiveWindow.VisibleRange(1, 1).Select
Why does the zoom range set differently between sheet1 and sheet2 when some of the rows are different heights but it is the same number of used columns?
Is there a better way to write this? I would like for it to only set the active zoom based columns with used cells.....