I have the following code to "join" the top three cells on a worksheet, then place some text inside this. I just cannot fathom out how to get the text left aligned (just for the joined cells).
Another strange phenomena that I am experiencing is that the text seems to be invisible on the worksheet, but magically reappears when all the data is pasted into a Word document.
' Join the top three cells ActiveCell.EntireRow.Range("A1:C1").Select Selection.HorizontalAlignment = xlCenterAcrossSelection ' Add line of text ActiveSheet.Range("A1").Value = "This is the history shown for the past eighteen months :-" & vbCrLf