Default font or style for a sheet.

Oct 19, 2010 at 10:49 PM

How would one set a default font for an entire sheet or workbook? Setting a style for a range of cells is easy enough, but then once the user scrolls past the range that you entered the font information for and begins typing they are back to using the default font (which on my setup seems to be calibrini 11 pt.



Oct 20, 2010 at 4:28 PM

Something like...

ws.Cells["A:XFD"].Style.Font.Name = "Arial";

I think there is some code like this in the Sample 7