Error 2029, Named Ranges, Unseen Cell Values

  • Thread starter Thread starter SDWinter
  • Start date Start date
S

SDWinter

I am working on a little VBA application in Excel 2000
that is exhibiting strange behavior. One of the functions
takes a named range on a worksheet and a numberic value
and performs linear interpolation on the data in the
range. Sometimes, the data in the named range is
not "seen" by the VBA function; sometimes it is. In trying
to track down the cause of this problem, I have tried
printing the values of the cells in the named range in the
Immediate Window of VBA. For some of the cells, I get the
proper value. For other cells in the range, I get Error
2029. I have been unable to find out what this error is.
Can someone provide this information?

Thank you!
 
Similar error 2029

Did you ever get this figured out?

I have an application that imports XLS files and occassionally when there is data that begins with an equal sign (=), excel thinks it is a formula and I get a type mismatch in VB but when I insepct the contents of the cell in the immediate window (and only there does this work) I get an "Error 2029".

I am trying to programitically detect this condition and correct it, but as soon as it happens, VB/Excel will not let me at the contents of the cell....

TIA,
-Dave
 
Back
Top