How do I link a cell to 2 non-bold cells and 1 bold cell and keep that formatting?

[ABKane]

If cell I7 is where that formula is and you're already using vba, then instead of that formula, use vba to place the value in it and format it, eg.:

With Range("I7")
  .Value = Range("A1").Value & Range("A3").Value & Range("B4").Value
  .Characters(Start:=Len(Range("A1").Value) + 1, Length:=Len(Range("A3").Value)).Font.FontStyle = "Bold"
End With

Fantastic!

This did do the trick to place it in one cell. Thanks for that!

Now there is one problem left. I want to copy that cell (the one containing the bold and not bold text) into my clipboard so that I can paste it into a Word document including the bold and non-bold formatting.

Any help with that?