Use vbCr instead of Chr(10) to create a hard return.

"StargateFanFromWork" schreef in bericht
...
When I've recorded a macro with text and have done the ^+Enter, the macro
records that as " & Chr(10) & ". The macros I have that do this have
worked for years without any problems. But here, in this new contract,
weird stuff is happening. I now get the error:

"Compile error: Can't find project or library"

The "Ch" in the above " & Chr(10) & " is then shown highlighted in dark
great and the title for the macro is highlighted in yellow.

What can we use in place of ^+Enter to create a hard return in a cell via
a macro, and so that " & Chr(10) & " isn't needed?

Thanks. :oD