Explore the fundamentals of arrays in vba, including dimensioning, lower and upper bounds, zero- and one-based indexing, and using dynamic arrays to transfer data between worksheets and memory.

Verify a variable is an allocated one-dimensional array in VBA using isarray, lbound, and ubound. Use on error resume next and check lower and upper bounds to return a boolean.

Develop a VBA 2D array index by value that mirrors worksheet match, searching rows or columns, returning the index or -1 with array validation and numeric handling.

Master the one-dimensional array match function to return the one-based position of a value, with a safe -1 default, using a simple loop and test case with a two-element array.

Demonstrates how to transpose a 2-D array in VBA using a temporary array and nested loops, returning the transposed result as a variant.

Learn to sum a specific column in a 2-D VBA array using a double accumulator, accommodate 0-based and 1-based bases, and validate numeric values for accurate results.

Toggle development and production modes to debug at customer sites, then use the restore stage function to return control, manage calculation mode, events, cursor, and screen updates.

Discover how to toggle between production and development modes in Excel VBA, using a hidden production flag to control error handling, On Error GoTo, and worksheet protection.

Restore the state of the application to normal after a VBA subroutine by reinstating screen updating, calculation mode, and events, returning control to the user and protecting sheet and workbook.

Learn how to import and export data with text files and CSV in Excel VBA, enabling ERP integrations. See meta data headers, line endings, records, and basic error handling.

Export a smart orders table to a csv file using a vba function, with optional header, full path or settings folder, and a configurable delimiter.

export a worksheet data as a csv file using the used range, with options to include or skip headers and metadata.

Export an array to csv by computing row and column counts from array bounds, handling optional metadata and section names for zero- or one-based arrays.

Import csv data into a worksheet using a dedicated import sheet data function. Learn meta data handling, header options, delimiter, and cell-by-cell writing with error checks and row count.

Explore system input/output functions to copy, move, delete files, check existence, verify file names, and list system drives, enabling VBA to interact with the operating system and manage files.

Extract the file name from a full path by using InStrRev to locate the path separator in reverse, then Mid to return the file name, even when no path exists.

Convert a file name to a windows legal file name by replacing illegal characters with underscores via a loop over a predefined illegal character list, returning the name if unchanged.

Delete all files in a folder older than a specified number of days using a file system object, returning the count of deleted files.

Master the move file function in VBA, moving a source file to a destination with an optional new name, handling existence checks, overwriting behavior, and error handling using late-bound FileSystemObject.

Demonstrate the copy file method to duplicate a file from one folder to another, rename it, and contrast it with the move file method through a test.

Learn to use the file exists function by listing files with the Dir function, matching patterns, and returning true or false with error handling via On Error Resume Next.

Learn to use Excel VBA notification functions to keep users informed during ongoing processes by displaying status bar messages and a wait cursor, via two practical subroutines.

Learn how to display messages in the Excel VBA status bar by using a public notify subroutine and the application.display status bar property to show and toggle messages.

Learn how the public notify off subroutine clears the status bar by sending an empty string and returning control to the application, allowing the app to reuse the status bar.

Explore three printing issues, verify the printer is ready before sending jobs, and learn to print a worksheet with repeating header rows via VBA.

Learn to check printer readiness in Excel VBA with a function that uses Windows management instrumental API to verify online status, handle default printers, and prevent duplicate prints.

Master the print worksheets subroutine to print a worksheet by name and verify printer readiness before printing. Use print preview to avoid actual printing and handle errors gracefully.

Learn how to use a VBA subroutine to set rows to repeat at the top in Excel's page setup, ensuring header rows print on every page.

Protect workbooks and worksheets with VBA functions, design safe user interventions, and preserve element and cell integrity while manipulating the workbook and responding to user actions.

Learn to unprotect the workbook using the unprotected workbook subroutine, the opposite of the protect method, enabling all workbook actions on the active or specified workbook.

Protect a single worksheet using the protect sheet subroutine, including optional workbook context, a password, and selective protection options like drawing objects and contents.

Unprotect a single worksheet by calling the worksheet’s unprotect method with the sheet name and optional workbook, supplying the same password used during protection, enabling edits after unprotect.

Learn how to protect all worksheets in a workbook with a single vba subroutine, including optional password prompts, workbook-wide protection, and flicker-free, secure execution.

Unprotect all worksheets in a workbook using the unprotect method with the correct password, test with wrong passwords, and verify worksheets become editable for data changes.

Design and format consistent Excel VBA reports by applying data and border formatting, headers, and conditional formatting, while clearing and repopulating the data region for every run.

Use a VBA subroutine to format a column of cells starting at row two. Format birth date, employment date, and quarter values, resize the range, and apply alignment.

Learn how to format a table column with a VBA subroutine, applying number formats and alignment to the data body range of an Excel table.

Master how to draw borders around a cell range using a versatile subroutine, specifying color, weight, and side selections (top, bottom, left, right, inner vertical, inner horizontal) for precise formatting.

Format a whole row in a report with a VBA subroutine, applying colors, font, size, and alignment to header or title rows. Demonstrates applying to a worksheet row.

Format a whole column of cells in a report by applying font color and interior color, with configurable rows, starting column, and optional multi-column formatting.

Apply conditional formatting formulas to a range or multiple columns in Excel with VBA, using relative references and formula conditions to color cells and set fonts in a report.

Master the clear report data subroutine to reset a dynamic Excel VBA report by clearing contents and formatting from the anchor, determining the last rows, and resetting row height.

Learn to simulate Excel's find text feature in a worksheet with VBA, including find next, error handling, and a friendly dialog when a string isn't found.

Get a column letter from a column index with get column letter function, using on error resume next, and extract letter from address property by splitting on the dollar sign.

Activate the start up worksheet specified by the user at workbook open, using a named range and On Error Resume Next to ensure a smooth start up.