John

one way:

With Selection
.Copy
.PasteSpecial _
Paste:=xlValues, _
Operation:=xlNone, _
SkipBlanks:=False, _
Transpose:=False
End With

Regards

Trevor


"JohnE" wrote in message
...
I have a button on a worksheet that uses code to place the
information in the proper cells. As part of the code I
actually have the formula that would go directly into the
cell. Upon using the button, all works. But, I need to
have the formula removed and only the info sitting in the
cell. I thought I had the solution until I used it on a
range of cells. Ouch, that was an error on my part. What
is the range().??? = range().??? that emliminates the
formulas but retains the info in the cell?
Thanks in advance to anyone responding.
*** John