I have a VB app that populates an excel spreadsheet very successfully, but now I want to do some formatiing and haven't a clue how.

I've done

Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlDataSheet As Excel.Worksheet
Dim xlSumSheet As Excel.Worksheet
Set xlApp = New Excel.Application
Set xlBook = xlApp.Workbooks.Open _
("c:\gandalf\template.xls", , True)
Set xlDataSheet = xlBook.Worksheets("Data")
Set xlSumSheet = xlBook.Worksheets("Sums")

to open up the excel file and a couple of worksheets, and I push data into them with no problem and can close and save, so my content is where I want it and now I'm interested in cosmetics.

I'd like to have row 3 in the "Data" sheet become all bold, and I'd like cell (5,2) in the Sums sheet to become bold

I'd appreciate any guidance.