Clean VBA Code: Combining Readability, Maintainability and Efficiency

Clean code is about clarity and intent.

Principles

• Small, single-purpose procedures
• No magic numbers (use constants)
• Avoid Select/Activate
• Fail fast with clear messages

Example

Const HEADER_ROW As Long = 1

Public Sub PrepareSheet(ByVal ws As Worksheet)
    With ws.Rows(HEADER_ROW)
        .Font.Bold = True
        .AutoFilter
    End With
End Sub

Reviews

• Use code reviews or at least self-reviews (diffs)
• Keep a formatting checklist
• Lint manually: search for Select, long procedures, missing Option Explicit