hi all
looking to edit single cells with rows(alt+enter) in them
eg a single cell with this in
Name1:ABC
Name2:ABCD
Name3:ABCDE
Name4:ABCDEF
change to/add lines
Name1:ABC
Name2:ABCD
Name2a:xxx
Name3:ABCDE
Name4:ABCDEF
Name4a:xxx
I recorded a macro,
but need something like
looking to isolate each row in cell if possible, thoughts/guidance and ideas appreciated
looking to edit single cells with rows(alt+enter) in them
eg a single cell with this in
Name1:ABC
Name2:ABCD
Name3:ABCDE
Name4:ABCDEF
change to/add lines
Name1:ABC
Name2:ABCD
Name2a:xxx
Name3:ABCDE
Name4:ABCDEF
Name4a:xxx
I recorded a macro,
Code:
ActiveCell.FormulaR1C1 = _ "Name1:ABC" & Chr(10) & "Name2:ABCD" & Chr(10) & "Name3:ABCDE" & Chr(10) & "[B][I]Name3a:ABCDE"[/I][/B] & Chr(10) & "Name4:ABCDEF" & Chr(10) & ""
but need something like
Code:
ActiveCell.FormulaR1C1 = _ Cell.row1.value & Chr(10) & Cell.row2.value & Chr(10) & Cell.row3.value& Chr(10) & "[B][I]Name3a:ABCDE"[/I][/B] & Chr(10) & Cell.row5.value& Chr(10) & ""
looking to isolate each row in cell if possible, thoughts/guidance and ideas appreciated
Last edited: