Ignore error checking in vba

I have an access 2003 application that is copying data from a recordset to an excel application opend in the background using the following

 Dim appExcel As Excel.Application
   Dim wbk As Excel.Workbook
   Dim wks As Excel.Worksheet

All seems to be working well except some of the data is resulting in excel displaying the little green triangle indicating a data format error.

I was trying to set a property that would prevent this from happening but can't seem to get the correct format.

Below is the code that loops through the addition of the fields to the excel spreadsheet
The  wks.Cells(iRow, iCol).Errors.Item(xlNumberAsText).Ignore = True is resulting in an object not set error

 For iCol = cStartColumn To cStartColumn + (rst.Fields.Count - 1)
         wks.Cells(iRow, iCol) = rst.Fields(iFld)
                       
         wks.Cells(iRow, iCol).WrapText = True
         wks.Cells(iRow, iCol).Errors.Item(xlNumberAsText).Ignore = True
         wks.Rows(iRow).VerticalAlignment = xlTop
         iFld = iFld + 1
      Next

any ideas?