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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s