[ExcelVBA] VBA code for finding row value

 

Hi friends..I do have problem with writing vba code..Can anyone help me?

Here is my senario - I do have data in several rows and collums. I would like to write vba script to find row value, according to "xfilter" which I Dim as Long.
If in the database have several same cell value, the script will run and give the first row value, when run again will give second row value and so on..Eg of Database :

Row/Collum A B
1 Amirul 123

2 Tariq 123

3 Amirul 789

If xFilter's value was "Amirul", first time the script run will give an answer "1"..Second time the script will give an answer "3".

If xFilter's value was "123", first time the script run will give an answer "1". Second time the script will give an answer "2"..

Please..Can anyone write a script for me? I really appreciate your kind effort..

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 5

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___