See my reply in the original thread. Post back to that thread if you need
more detail.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

justaguyfromky wrote:
.Range(.Range("T32").Text).Copy
Destination:=.Range(.Range("T35").Text)

This is a formula that works the way I need it to with the exception
of...

I need it to paste only the values, not the formula from the copied
cell

Any help will be greatly appreciated

Thanks