View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Beckinsale Michael Beckinsale is offline
external usenet poster
 
Posts: 80
Default 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