This code below looks at field c2 in hours worksheet and writes the text "hours" x amount of times based on the value in that field to the work worksheet. It works great BUT I need it to round DOWN any .5 value instead of rounding up. Is that possible? Can I put like an IF statement that specifies what to do if the value is x.5?
Sub Test() Application.ScreenUpdating = False Dim bottomD As Long bottomD = Sheets("Work").Range("D" & Rows.Count).End(xlUp).Row Sheets("Work").Range("D" & bottomD + 1 & ":D" & bottomD + Math.Round(Sheets("Hours").Range("C2"), 0)) = "HOURS" Application.ScreenUpdating = True End Sub