View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Tom is offline
external usenet poster
 
Posts: 3
Default problem with text from macro?

When I record my macro, to insert a <CR in a column heading cell, the macro
editor shows:

Range("E1").Select
ActiveCell.FormulaR1C1 = "Read" & Chr(10) & "YY"

Yet when I run my macro, what gets inserted appears to *not* be a <CR.
Instead, there's a thick vertical line (like a bold "I") where the <CR should
be. If I edit that cell (<F-2), then hit <Enter, I get what I originally
wanted:

Read
YY

instead of:

Read|YY

On the one hand, this isn't really a big deal, but if I'm doing something
wrong...

Thanks in advance,

Tom