j$ = "THIS MACRO WILL ERASE THE SECOND & THIRD SET OF DATA" + Chr$(13) +
Chr$(13)
Using EXCEL 2007, I get an error with the line above as a macro.
It does not recognize CHR$.
What am I doing wrong?
Thanks

Not for me it didn't.

Check for MISSING references in ToolsReferences, uncheck them if there are
any.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"pcor" wrote in message
...
j$ = "THIS MACRO WILL ERASE THE SECOND & THIRD SET OF DATA" + Chr$(13) +
Chr$(13)
Using EXCEL 2007, I get an error with the line above as a macro.
It does not recognize CHR$.
What am I doing wrong?
Thanks

Still acting up?
It works for me as you wrote it, using either + or & to do the
concatenation, and using either CHR(13) or CHR$(13) [or one of each, even].

I actually prefer & when concatenating strings, but the + should work as
well for you in this context.

"pcor" wrote:

j$ = "THIS MACRO WILL ERASE THE SECOND & THIRD SET OF DATA" + Chr$(13) +
Chr$(13)
Using EXCEL 2007, I get an error with the line above as a macro.
It does not recognize CHR$.
What am I doing wrong?
Thanks