12. Macros and VBA

12.5 Sub Procedures

By Ravindra Bagale · Last updated: 25 September 2026

A macro is a Sub procedure: it starts with Sub Name() and ends with End Sub. Comments start with an apostrophe '.

Option Explicit

Sub HelloBlinkit()
    ' My first macro
    Worksheets("Report").Range("A1").Value = "Blinkit Maharashtra - Daily Report"
    Worksheets("Report").Range("A2").Value = Date
    Worksheets("Report").Range("A2").NumberFormat = "dd-mm-yyyy"
    MsgBox "Report header ready!", vbInformation, "Done"
End Sub

• Run: put the cursor inside the Sub and press F5.
• One Sub can call another: Call FormatHeader or just FormatHeader.
• Private Sub hides a macro from the Macros dialog (useful for helper procedures).
• Line continuation: end a line with a space and underscore _ to continue on the next line.