Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Countif - problem counting text, other text | Excel Worksheet Functions | |||
Text to columns macro problem | Excel Discussion (Misc queries) | |||
Autofit with Merged Cells/Wrap Text Macro Problem | Excel Discussion (Misc queries) | |||
Large amount of text in cells - Problem text.xls (0/1) | Excel Discussion (Misc queries) | |||
Large amount of text in cells - Problem text.xls (1/1) | Excel Discussion (Misc queries) |