Thanks for your response, Gary! The post above solved the problem quite
simply.

You did the same thing I attempted to do and wasn't satisfied with --
created code. It works, but I was trying for something easier for the user.
The problem with the code was finding an event to fire it in. The only way
around it I found was to create a button which I did not really want to do.

Thanks so much for replying, however!
--
Sandy


"Gary Keramidas" wrote:

will this work?

Sub copy_Values()
Range("P2:P500") = Range("a2:a500").Value
End Sub
--


Gary


"Sandy" wrote in message
...
Hello -

I have a formula in A2:A500. I need to put the value of that formula (in
other words, the text it generates) into P2:P500.

What's the best way to accomplish this?

Any help will be greatly appreciated!
--
Sandy