Focused on Excel VBA macros

Generate, repair, modify or explain Excel VBA. Include the expected result, triggering steps and error when reporting a problem.