How to add prefix in VBA to link with values

[vbanewbie68]

Dear sir or madam,

I need some help on how to add a prefix on the Gift Reference?

For example, under the column for Gift reference: ch_3JmFlIBMqdoOacPd1nIewWoV - I have copied the Transaction ID data column using VBA, and automatically put it onto the Gift Reference.

Now on the Gift Reference column I want to add a prefix free text myself to the donation like this ch_3JmFlIBMqdoOacPd1nIewWoV _donation.

By looking at this line in VBA, see the following, where I want to add a prefix to allow me to type _donation at the end.

Import.Cells(x, GiftReference).Value = Cells(x, TransactionID).Value

I hope this makes sense

Best Regards

 

[Fluff]

How about

Import.Cells(x, GiftReference).Value = Cells(x, TransactionID).Value & "_donation"

 

[vbanewbie68]

How about

Import.Cells(x, GiftReference).Value = Cells(x, TransactionID).Value & "_donation"

That is great and it works. Many thanks for your time on this matter which is much appreciated
Best regards
Vbanewbie68

 

[Fluff]

You're welcome & thanks for the feedback.