appXL1.ActiveSheet.Cells(Number, 3).Value = txtQty.Text

the above statement when i key in txtQty.Text as numbers....the spreadsheet could show the numbers however when i key in letters..error: application-defined or object dfined error....why?