Prev: re. Mapping Software
Next: Number to time conversion
From: Jake on 3 Mar 2010 16:20
I notice that when the below rounding macro is used on a formula instead of a
number, it converts the formula to its calculated number. Is there a macro
that will add the +ROUND() to cells while preserving the formula within the
cell? Thanks in advance for your help!

"Gary''s Student" wrote:

> Select the cells you want to convert and run this macro:
>
> Sub round_um()
> Set rr = Selection
> For Each r In Selection
> r.Formula = "=ROUND(" & r.Value & ",0)"
> Next
> End Sub
>
> --
> Gary''s Student - gsnu200798
>
>
> "Eastar" wrote:
>
> > data shown as below
> > a b
> > 1 5.2312 6.1231
> > 2 15.2323 15.46463
> >
> > How can I add a round() formula to every cell without doing that to each of
> > them seprately?
> >
> > thanks,
> >
 | 
Pages: 1
Prev: re. Mapping Software
Next: Number to time conversion