address of cell

[sunny2u86]

hi
help me pls...

my question is

A B c
1 as
2 ad
3 sd
4 dg
5 ki
6 we
7 rt
8 ty
9 ru

my question is that is there is any vba code that will give me the location of the searched element,say i searched"ki" then it wiil show result "5" in column B or c any...

[tom1977]

hi look at attachment

sorry you wanted VBA so

Sub aa()

MsgBox Application.WorksheetFunction.Match("ki", Cells.Columns(1))

End Sub

[dilipandey]

Hi Sunny,

See the attachment where I have tried extracting the address of the cell. let me know if this is what you were looking for. Thanks.


Regards,
DILIPandey


<click on below 'star' if this helps>