.
Option Explicit

Sub rundates()

    Dim early As Date, late As Date
    Dim dt As Date
   
    early = "10/25/2018"

    late = "10/30/2018"

        dt = Now()
        If dt <= late And dt >= early Then

            MsgBox "Hello" '<-- replace this with your macro code or a call to your macro code located elsewhere.

        End If

End Sub