Combine two or more column cell data by Defined function.

Before I post How to combine two or more column cell by  Combine function .Now this combine process very easy VB code .
Defined a function create at first then this function use in cell where you combine .Use this chain function. Enjoy!

Function Chain(myRange As Range) As String
 Dim c As Range
 For Each c In myRange.Cells
  Chain = Chain & c.Value
 Next c
End Function

Download the workbook.

Tweet