To format all of column "C": oExcel.Workbooks(lcWorkbookName).Worksheets(lcWorksheetName).Columns("C").NumberFormat = "$#,##0.00" To format all of Row 4: oExcel.Workbooks(lcWorkbookName).Worksheets(lcWorksheetName).Rows(4).NumberFormat = "$#,##0.00" To format a the range A17 to C30 oExcel.Workbooks(lcWorkbookName).Worksheets(lcWorksheetName).Range("A17:C30").NumberFormatThe RANGE() property also takes RANGE(CELLS(x,y), CELLS(x,y)) if you don't know the letter of the column