Thread: Find method
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sajit Sajit is offline
external usenet poster
 
Posts: 30
Default Find method

The help for the find method tells me,

"Finds specific information in a range, and returns a Range object that
represents the first cell where that information is found. Returns Nothing if
no match is found. Doesnt affect the selection or the active cell."

But I see that the result of the find in the expression,

range1.find("text1")

finds the text1 string itself and not the cell reference. For this I have to
have,

range1.find("text1").row

however this returns the absolute row reference and not relative to the range.

1) Why does not the find method return a result as in the help?
2) How do I get a row reference relative to the range?

--
Sajit
Abu Dhabi