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