Find method fails in Excel 2003 ("Subscript out of range")

[Guy Jara]

I have encountered a curious anomaly, and a solve for it, that is
related to Excel 2003. There are 2 constants in the Excel VBA
environment that look almost alike: xlValue and xlValues. The first is
a constant associated with the Axis of the graph object (I believe).
The second is a constant used by the Find method of the Range object in
Excel.

I encountered a situation where code utilizing the Find method that was
running in Excel 2000 now bombed with a "Subscript out of range" error
when run on Excel 2003. The problem was that the original code used the
incorrect "xlValue" constant with the Find method, rather than the
appropriate "xlValues" constant. Excel 2000 seemed to take such
sloppiness in stride and actually worked despited receiving the wrong
parameter value. However, Excel 2003 is more finicky and bombed when
passed the incorrect constant.

So word to the wise. Excel 2003 is more finicky.

 

[NickHK]

Guy,
Can't say I've ever noticed that, but
http://msdn.microsoft.com/library/e...t.asp?frame=true#wrgrfexcelrangeobjectanchor4
says to use "xlValue" (although xlComments and xlFormulas, plural are
shown), whilst VBA help gets it *right*.
All I can only assume that this was a bug that was fixed in Excel 2003,
although I can find no mention of it.

NickHK