Too late, Gord, he's already done it using Word. Anyway, Dave told him
that yesterday.

Pete

Gord Dibben wrote:
David

There is no exclamation mark in my code.

I think that when you copied the code you also copied the Usage instructions.

Just copy the part from

Function ConCatRange(CellBlock As Range) As String

down to and including

End Function


Gord

On Fri, 1 Sep 2006 09:33:51 +0100, "David" wrote:

Many thanks for this. But I keep getting the message'Compile Error:
Expected: list seperator or )' and the exclamation mark in the code becomes
highlighted.

David

Gord Dibben MS Excel MVP