If I enter carriage returns of Chr(10) in a cell, I cant seem to select the cell heading in the code below unless i take out the Chr(10) code. Is there a trick to this please?
' Extra Headings
.Cells(row, col + 1).FormulaR1C1 = "Calc" & Chr(10) & "Eval Date"
'...