Questions and Answers on Excel Macros (VBA)

Level: General
Topic: Working as Consultant in Excel

Level: Intermediate
Topic: How do I look for a series of characters?

Level: Intermediate
Topic: Macros not showing?

Level: Intermediate
Topic: Making sure that the file is not saved on itself

Level: Intermediate
Topic: Are "If" statements and "Select Case" case sensitive?

Level: Beginner
Topic: What is the difference between "Delete" and "ClearContents"?

Level: Intermediate
Topic: Is ActiveSheet in ThisWorkbook?

Level: Intermediate
Topic: Saving a workbook using the date?

Level:Advance
Topic: Inserting a worksheet into a variable

See these answers and many more in the
Downloadable Tutorial on Excel Macros