I run this code with the intent of bolding the selected range of charactes
// this resets the font from Courier New to Arial
wks.Cells[3, 1].Characters(r.Start, r.Length).Font.IsBold = true;
How can I preserve or reset the font? I have tried setting the font name back to Courier New immediately after this statement, but it does not keep it.
See rows report.xls where the entire report is supposed to be Courier New. but the bolded parts of rows 3, 4, and 5 are Arial.
Thanks.