Thanks for the examples, however I have version 7.1 and the example you sent me was 8.0 . Do you have it in 7.1 ?
Thanks for the examples, it was a great help. However, there is one small problem. The find property does not give an option to Match Entire Cell contents similar to the tool used in excel. Do you know if it is possible to do that in Active X ?
Wire a true constant to "look at" in the find property. Wiring a true to this property tells it to match entire cell or xlWhole and wiring a false tells it to match part or xlPart.
One quick way to find this out is record a macro in excel then edit the macro so that you can see what is going on and try to duplicate it in LV. there is all kinds of hints and tricks in a discussion in the breakpoint about excel.