Excel cell taking only Integer Values

  • Thread starter Thread starter Ashish
  • Start date Start date
A

Ashish

Hello,



When I write in a Cell in Excel if I am writing integer then Cell takes that
Value but if I write a string value then I cannot see anything in Excel
File.



_objRange = _objWorkSheet.Range(_objWorkSheet.Cells(_intCurrentRow,
17), _objWorkSheet.Cells(_intCurrentRow, 18))

_objRange.Value = "String Value"



This is happening in Excel 2000 (10.0) on WindowsXP.



Thanks and Regards,

Ashish
 
This is usual behaviour for cells formatted as numbers - when any text
zero value.

You need to reformat the cells as General or Text
 
In plain old VBA, I'd have to use a Set with that first line:

set _objRange = ....

Otherwise, I'd get an error on either the first or the second statement.

And are you sure you're checking the correct worksheet and the correct cells?
 
Back
Top