VBA How to round a value that is copied or a range that is being pasted ?

[VytautasM]

Good day,

Looking for a way to round a value I am trying to copy or the range I am trying to paste.

The code is below. Tried inserting

Round.

, but do not seem to find the correct placement. Also tried

numberFormat = "0.0"

.

Could round the whole column after pasting in the values, but would like something a bit more streamlined and accurate.

Any suggestion on how to implement rounding ?

                wsinput.range("N" & fr + 1).copy
                If wsoutput.range("C" & lroutput + 2).End(xlDown).Row = 1048576 Then
                   wsoutput.range("AE" & lroutput + 1 & ":" & "AE" & lroutput + 2).PasteSpecial paste:=xlPasteValues
                   wsoutput.range("V" & lroutput + 1 & ":" & "V" & lroutput + 2).Value = "=IFERROR(RC[5]*(1-RC[9]),"""")"
                Else
                   wsoutput.range("AE" & lroutput + 1 & ":" & "AE" & wsoutput.range("C" & lroutput + 2).End(xlDown).Row).PasteSpecial paste:=xlPasteValues
                   wsoutput.range("V" & lroutput + 1 & ":" & "V" & wsoutput.range("C" & lroutput + 2).End(xlDown).Row).Value = "=IFERROR(RC[5]*(1-RC[9]),"""")"
                End If