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