Populate the Concatenate function using VBA
Hi All,
Bit of a strange one this!
I need to concatenate several columns (actually 70) and wondered if the
Concatenate Function could be populated using VBA.
Does anybody have the code to do this or able to point me in the right
direction please ?
I realise that the function is limited to 30 columns but l could do the
concatenate 3 times then concatenate them.
TIA
Michael Beckinsale
|