I am trying to find the vba code for rounding a number to the nearest 0.5. I have found the following:

ActiveCell = WorksheetFunction.MRound(ActiveCell, 0.5)

But what comes before and after it in the vba window? i.e Option Explicit / Private Sub Workbook..............etc. Additionally, I assume I need to define the range that this format should apply to:

Range("C27:G37").Select

Many thanks