View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Grant Grant is offline
external usenet poster
 
Posts: 27
Default Range.Text/Value returning the number 3?

Hi,

I am using VB.Net (Interop) and when I try to retrieve a value from a cell
it returns the number 3 instead of the actual value that is in the cell.

It happens for some of my cells, but others seem to work fine - I have no
idea what is happening.

I use Range("B4").Value or Range("B4").Text and also tried
Range("B4").FormulaR1C1, but still get that strange number 3 turning up.

Any ideas?

Thanks in advance,

Grant.