err_handler

  1. H

    Outlook - UserForm open in center of New Email Window

    I added a button to the ribbon of a New Email Window that when clicked opens up a UserForm. I would like for that UserForm to open up on the center of that New Email Window. Below is the code that I have so far. Sub Add_Client_ID() Dim wdDoc As Object Dim oRng As Object Dim oBM As Object Dim...
  2. T

    Macro Adjustment

    Hi! I would like to adjust this macro so that instead of being applied to every sheet, it looks up a range of tab names, and is only applied to those tabs. Any help would be much appreciated! Sub Hide_All_Rows() Dim r As Range Dim ws As Worksheet On Error GoTo err_handler...
  3. T

    Macro Adjustment for Unhiding Rows

    Hi! Would someone be able to adjust this macro to unhide all rows? Sub Hide_All_Rows() Dim r As Range Dim ws As Worksheet On Error GoTo err_handler Application.ScreenUpdating = False For Each ws In Worksheets For Each r In ws.Range("ZZ1:ZZ1000") If r.Value = 1 Then...

Some videos you may like

This Week's Hot Topics

Top