MrExcel's Learn Excel #587 - Concatenate Range in VBA

Back in Episode 578, I used an incredibly complex method using NotePad for joining cells together. Today, Jonathan from the UK points out that a few lines of VBA code would have made the solution incredibly simple. Episode 587 shows you how.


Function ConcatenateRange(rCells As Range)
Dim vTemp As Variant
Application.Volatile

For Each vTemp In rCells ConcatenateRange = ConcatenateRange & vTemp & " "
Next vTemp
End Function




This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Category:

People & Blogs

Tags:

• Excel
• business
• accounting
• spreadsheets
• tutorial
• technology
• MrExcel
• VBA

[RandyKelly19]

Do you have one for 2010?