ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   problem with text from macro? (https://www.excelbanter.com/excel-programming/332329-problem-text-macro.html)

Tom

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



All times are GMT +1. The time now is 12:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com