View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
xgirl xgirl is offline
external usenet poster
 
Posts: 11
Default 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?