Combine data in cells
Hi, I'm trying to write a macro that will combine the contents of 2 cells in
to one with a line feed between each.
I tried to use vblf or chr(10) but it doesn't work.
ActiveCell.Formula = "=$n$1&H5" & vbLf & "$0$1&H4"
Any suggestions?
|