EXCEL 2007 acting up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Tools>References, uncheck them if there are
any.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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.
 
Back
Top