Worksheets

Unprotecting and Protecting: Explains how to protect and unprotect sheets using VBA. Useful when you want your sheets to remain protected from the end-user but remain unprotected from the program.
Referencing Cells and Ranges in Different Worksheets: Explains how you can modify cells and ranges that are in a different worksheet
Searching: Explains the basic algorithm to search for a value.
Working With Sheets: Explains the different ways of referencing a worksheet, the difference between a worksheets name, index and variable name. Also explains how to create and copy a worksheet.