View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ManualMan ManualMan is offline
external usenet poster
 
Posts: 35
Default Add cell content to another cell

Hi, This would do the trick i think

Sub ConcatenateTwoCells()
Src = InputBox("Which cell's content do you want to append to another
cell?")
Dst = InputBox("To which cell do you want to append the contents of
cell " & Src)
Range(Dst) = Range(Dst) & Range(Src)
End Sub

Regards,
ManualMan
http://www.gamesXL.tk