>oRange = oWorkbook.Sheets[1].range("A1", "B2") >oRange.Interior.ColorIndex = 41 >oRange.Font.Name= "corbel" >oRange.Font.Size= 11 >oRange.Font.Italic = .T. >oRange.Font.Bold = .T. >oRange.font.ColorIndex = 19 >Check out the Borders collection. Here's the Help for the 2007 version, but it shouldn't be terribly different, whatever version you're using: http://msdn.microsoft.com/en-us/library/office/bb210096%28v=office.12%29.aspx