VBA Code Snippets

This page contains sections of common sections of code, which you can learn from, copy straight into your VBA projects, or just to remind you of the syntax.

Contents:

• Application Settings
• Arrays
• Cells and Ranges
• Files
• Folders / directories
• Loops
• Named Ranges
• PowerPoint
• Workbooks
• Worksheets
• Zip and Unzip files and folders

Application Settings

Control Custom Lists with VBA

Arrays

Sorting an array alphabetically with VBA

Cells and Ranges

Cell and Range VBA properties and actions

Files

Selecting a file using the File Dialog Box

Reading document properties

Find out if a file is already open by you or another user

Loop through all the files in a folder (and sub folders)

Copy, move, rename, delete and confirm existence of files

Zip and unzip files

Folders / Directories

Create, delete, rename and confirm existence of folders

Loop through all the files in a folder (and sub folders)

Zip and unzip folders

Loops

Loop through every worksheet or every workbook

Loop through all the files in a folder (and sub folders)

Named Ranges

Named Ranges – VBA properties & actions

PowerPoint

PowerPoint VBA Reference Library

Workbooks

Loop through every worksheet or every workbook

Workbook properties and actions

Worksheets

Loop through every worksheet or every workbook

Zip and Unzip files and folders

VBA code to Zip and unzipping files and folders

Save