MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Automating a process for consolidating rows of data from several tabs into one summary tab in an Excel workbook on an ongoing basis||2||36|
|need help to look for||16||42|
|need count all combination||31||30|
|Modifying VBA to exclude a single row of data when extracted to another workbook||7||16|
Join the community of 500,000 technology professionals and ask your questions.