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,
ActiveCell.FormulaR1C1 = _...