B
BEEJAY
Greetings:
Have variable length of cells in column M, to be concatenated and entered in
C (3 rows below last row).
Trying:
Range("C:C" & LastRow + 3) ' Cell to receive concatenated result
Then need something like:
=Concatenate(M9&M10&M11 etc - to last row.
Column M already contains the data with required commas and spaces inserted,
ready to do the required searches in an "in house" program.
Thank you
Have variable length of cells in column M, to be concatenated and entered in
C (3 rows below last row).
Trying:
Range("C:C" & LastRow + 3) ' Cell to receive concatenated result
Then need something like:
=Concatenate(M9&M10&M11 etc - to last row.
Column M already contains the data with required commas and spaces inserted,
ready to do the required searches in an "in house" program.
Thank you