"avveerkar" wrote
in message ...

( it is CHR$ not CHR )


It's both. And there's very little to choose between the two. Chr$ is
marginally more efficient, but will make such a disappearingly small
improvement in an average Excel/VBA application that, in reality, it matters
not which you use.

Robert