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.

Leave a Reply

Your email address will not be published. Required fields are marked *