Moving numbers to two decimal places i think...

4

4ndy

just incase anyone else has the same problem ill post my problem an
answer here

Problem=
the round function and roundup functions dissapear and just leave th
answer therefore not continuosley updating the values

Answer i pasted this little script into my vbasic code just before th
next userform opened =
Range("J18").Select
ActiveCell.FormulaR1C1 = "=ROUNDUP(RC[-4],2)"
Range("J20").Select
ActiveCell.FormulaR1C1 = "=ROUNDUP(RC[-4],2)"
Range("J22").Select
ActiveCell.FormulaR1C1 = "=ROUNDUP(RC[-4],2)"
Range("J23").Selec
 
Top