Sentence construction using VBA.

Hi Zainab,

Thank you for the forum question.

If you want to concatenate cells into a sentence you can use the concatenate function. See example below.

ctiveCell.FormulaR1C1 = _
"=CONCATENATE(RC[-5]& "" "",RC[-4]&"" "",RC[-3]&"" "",RC[-2]&"" "",RC[-1])"

I just recorded this. To get a space between each word you need to use & " " after each cell reference.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector