VBA and VB.Net Tutorials, Education and Programming Services
- 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.