Who can help me with this 'simple' issue ?
Suppose I have an item to search for in A1, A3 and A10
My position is in A6 and want to find the item in column A ABOVE A6, so the result should be A3.
Still my find function finds A1 first.
I am using this code:
It does not seem to matter if I change the search order from SearchDirection:=xlUp to SearchDirection:=xlDown
Please Login or Register to view this content.
What am I missing here ?
Thankx,
Arnold
Pease don't duplicate posts.
Entia non sunt multiplicanda sine necessitate
--------------------------
If solved remember to mark Thread as solved
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
http://www.excelforum.com/excel-prog...direction.html
Thread Closed.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks