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!
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!