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?
Private Sub Workbook_SheetActivate(ByVal Sh As Object) ActiveSheet.UsedRange.Resize(ActiveSheet.UsedRange.Columns.Count).Select ActiveWindow.Zoom = True: ActiveWindow.VisibleRange(1, 1).Select End Sub
|splitting text of cell to columns||14||24|
|Auto populate in Cascade dropdown||3||27|
|Comparison between two sheet and addition of an item from second sheet - Excel Query AP||5||18|
|Update Access FrontEnd by Version #||9||25|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!