Paste values only
 

..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

Paste values only
 

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