Macro Modification

Sub Package()

Range("L2").Select
Do
If ActiveCell.Value = "" Then
ActiveCell.Value = "=((ROUNDUP((RC[-1]/1.5),0))*1.5)"
ActiveCell.Value = ActiveCell.Value
ActiveCell.Offset(1, 0).Select
Else
ActiveCell.Offset(1, 0).Select
End If
Loop Until IsEmpty(ActiveCell.Offset(0, -2))
End Sub


dear friends after running above macro if cell values 31.5,33,61.5,63 then this all 4 values need to replace with 34.5.pls make this for me.thanks,,,

Please change your QUOTE tags to CODE tags, and amend your thread title to describe your problem.

Thanks.