ClulessChris
IS-IT--Management
a corporate system outputs data into an Excel spreadsheet. cell that have line feeds are displayed:
aaabbb, but on double click the cell is expanded and displays:
aaa
bbb
I've trying to replicate this for all used cells. A recorded macro shows:
and if I debug.print ActiveCell.text before expanding the cell I get:
aaa
bbb
Any pointers gratefully received
Regards
aaabbb, but on double click the cell is expanded and displays:
aaa
bbb
I've trying to replicate this for all used cells. A recorded macro shows:
Code:
Range("A11").Select
ActiveCell.FormulaR1C1 = "TIN" & Chr(10) & "TIN" & Chr(10) & ""
aaa
bbb
Any pointers gratefully received
Regards