On Error statement Archives - ExcelBaby

Learn

Excel Macro: Adjust All Pivot Data Field Titles

When you create a PivotTable, Excel prefixes the title of each data field with Sum of, Count of. If you want the […]

PivotField.Caption property PivotField.SourceName property Is operator PivotTable.Name property Chr function Nothing keyword For Each...Next statement On Error statement

Learn

Excel Macro: Hide All Subtotals in a PivotTable

This simple macro hides all subtotals in the specified PivotTable. Tips You can manually hide all subtotals at once by going to […]

Is operator PivotTable.Name property Nothing keyword For Each...Next statement On Error statement

Learn

Excel Macro: Limit The Number of Times a Workbook Can Be Used

Suppose you want to send a demo file for users to check, but you don't want it to be used more than […]

Workbook.FullName property Kill statement Workbook.ChangeFileAccess method DocumentProperties.Add method Choose function MsoDocProperties enumeration Workbook.CustomDocumentProperties property Workbook.BeforeSave event Workbook.RemovePersonalInformation property Workbook.Close method Workbook.Saved property Workbook.Open event Workbook.Save method With statement If...Then...Else statement On Error statement

Learn

Excel Macro: Enable Trust Access to the VBA Project Object Model

Enabling trust access to the VBA project object model allows you to write automated Excel programs and manipulate the VBA environment and […]

Application.SendKeys method On Error statement

Learn

Excel Macro: Highlight the Active Row and Column

The VBA code examples show ways to highlight the active cell or the rows and columns that contain the active cell. Get the VBA code now!

Range.Column property Range.CurrentRegion property Range.Select method Range.EntireColumn property Range.EntireRow property IsEmpty function Worksheet.SelectionChange event Worksheet.BeforeDoubleClick event Application.ScreenUpdating property Interior.ColorIndex property Range.Interior property Range.Address property On Error statement

Learn

Excel Macro: Create a Table of Contents of Sheets

This Excel macro not only creates a table of contents at the beginning of the workbook, but it also adds hyperlinks. Get this VBA code now!

Hyperlinks.Add method Application.ScreenUpdating property Worksheet.Name property Sheets.Add method Application.DisplayAlerts property For...Next statement On Error statement

Learn

Excel Macro: Protect or Unprotect All Worksheets At Once

Is there any way to have a Macro protect or unprotect multiple worksheets at once in Excel quickly and easily? This Macro do this! Get it now!

InputBox function Worksheet.Unprotect method Worksheet.Protect method MsgBox function For Each...Next statement If...Then...Else statement On Error statement

Learn

Excel Macro: Add and Name a New Worksheet with Specific Name

If you always add and name a new Worksheet with specific name in your Workbook, this simple macro can help you. Get this VBA code now!

Sheets.Add method MsgBox function On Error statement

Learn

Excel Macro: Create, Copy, and Delete Folders

We can create, copy and delete specified folders using Folder object or FileSystemObject object in VBA. Get this VBA code now!

Err.Description property Copy method Folder.SubFolders property FileSystemObject.GetFolder method FileSystemObject.DeleteFolder method FileSystemObject.CreateFolder method FileSystemObject.CopyFolder method FileSystemObject.FolderExists method On Error statement

Learn

Excel Macro: Rename a File or Folder

You can rename and move a specified file or folder using the built-in Name statement in VBA. Download this Excel macro now!

Name statement On Error statement Dir function

Learn

Excel Macro: Determine If a Excel Workbook is Already Open

This Excel custom function can be used to determine if a excel workbook is already open or not. Get this VBA code now!

Err.Number property Function statement On Error statement

Docs

On Error statement

Enables an error-handling routine and specifies the location of the routine within a procedure; can also be used to disable an error-handling […]

On Error statement