![]() |
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