Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find Method Help in VBA | Excel Programming | |||
xls vba find method to find row that contains the current date | Excel Programming | |||
Find Method | Excel Programming | |||
date find using find method | Excel Programming | |||
Using variables to make a date and using find method to find that. | Excel Programming |