Bearing in mind that my VBA knowledge is very basic, could I please ask for some help with some number structure.
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
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