Issues with Concatenating when a cell contains 287 spaces

Hi All,

I have an issue whereby I receive a runtime error 13 when I run a concatenate macro.

I have narrowed it down to the fact that my last cell for concatenation contains 287 spaces.

When running my macro with the cells containing simple text words like cat, dog etc; the macro runs perfectly.

The code for my concatenate function is:

Please Login or Register  to view this content.

Many thanks in advance for any assistance that can be rendered.

hi DDR, transpose function has limitation of 255 symbols maximum for each array element of the array being transposed. Why not to use simple "&" for those 7 cells?

Hi Watersev,

In doing this how would I achieve the same result using the & please?


Many thanks in advance.

Hi Watersev,

In doing this how would I achieve the same result using the & please?


Many thanks in advance.

Hi Watersev,

Thanks for this. Works perfectly in terms of Concatenation.

The only other question I have is, how do I ensure that the formatting remains the same after the concatenation?

I've attached a copy of the sheet.


Many thanks for all your help.