oExcel.ActiveSheet.Columns[2].ColumnWidth =.ColumnWidth + 2Change the alignment of a range of cells (other constants are available):
#DEFINE xlHAlignCenter -4108 oSheet.Range("A5:C5").HorizontalAlignment = xlHAlignCenterWhen you record a macro, you'll see a ton of constants. For information on how to find the values of those constants so you can define them, see the very last question on this page: http://www.hentzenwerke.com/catalogavailability/autofoxfaq.htm
WITH oSheet.Range("B2").Font .Name = "Times New Roman" .Size = 14 .Bold = .T. ENDWITHHope this helps,