Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

formulas to values

6 views
Skip to first unread message

Ron de Bruin

unread,
Dec 4, 2002, 12:14:30 PM12/4/02
to
Range("d1:d3").Value = Range("d1:d3").Value

Use somthing like this

--
Regards Ron
www.rondebruin.nl


"Derek" <haw...@hotmail.com> schreef in bericht
news:00c301c29bb7$c7495eb0$d4f82ecf@TK2MSFTNGXA11...
> I have a group of cells with formulas. Is there an easy
> way to remove the formulas and replace them with the
> current cell values (without doing a copy -> paste
> special -> values only). Thanks in advance...


Derek

unread,
Dec 4, 2002, 1:59:52 PM12/4/02
to
Thanks Ron...works nicely.
>.
>
0 new messages