Hello,
I'm having a small problem here, or rather a question.
I have 3 values (firstname, secondname, place) that I need lookup in a list of items.
I want to return the row where all 3 the names are found in the list.
Problem of course is that each value can appear more then once in the list, but the combination is always unique.
Something like this would be nice:
iRow = datasheet.Rows.Find(What:=(firstname And Secondname And Place), SearchOrder:=xlRows, SearchDirection:=xlPrevious, LookIn:=xlValues).Row
But that doesn't work, so anyone with better ideas is more then welcome to share them
Bookmarks