copy/paste vlookup

[colinharwood]

Hi

In cell X6 I have =VLOOKUP(X2,'TMES Members'!A6:'TMES Members'!S97,16,FALSE) which evaluates to a value of £10.00

and in cell U40 Ihave =CONCATENATE("This is a receipt for your annual subscription of "&X6&" and is proof of your")

When using a macro to copy U40 and paste it in cell A1, the result in A1 is This is a receipt for your annual subscription of £10.00 and is proof of your

Is there a way to get =CONCATENATE("This is a receipt for your annual subscription of "&X6&" and is proof of your") in A1 instead.

Thanks

 

[etaf]

=U40
will that work, instead of a macro

 

[colinharwood]

Wayne
Thanks for that. I have just found that paste as a link was the answer.
Colin

 

[etaf]

glad to have helped