Topics

• Methods for Finding the Last Used Row or Column in a Worksheet
• Merged Cells / Ranges
• Passing Arguments ByRef or ByVal
• Queries
• Creating a drop-down menu in the Active Worksheet with a Combo Box

Examples

• Find the Last Non-Empty Cell in a Column
• Find the Last Non-Empty Column in Worksheet
• Find the Last Non-Empty Row in Worksheet
• Find the Last Non-Empty Cell in a Row
• Think twice before using Merged Cells/Ranges
• Passing Simple Variables ByRef And ByVal
• ByRef
• Basic Query
• Multi-Tables Query
• Jimi Hendrix Menu