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
|