Range.Find skips the first cell ??
What do you want it to do instead?
The example in Help has useful code.
Tim.
--
Tim Williams
Palo Alto, CA
"slintz" wrote in message
...
It seems that a straight forward Range.Find() call implicitly starts
searching AFTER the first cell in the range, AS IF called as
f = r.Find(after:=r.cells(1,1),...)
This work-around is effective:
f = r.find(after:=r.cells(r.Rows.Count, r.Columns.Count),...)
but it's (obviously) fugly. Am I missing something?
|