Find out the Row and Column address number of the searched cell (separately)

Hi All,

I have written below codes to find the searched cell address, but it is not working, when I want to know the searched cell's Row and Column number individually, (so that I can use them for my further codes or procedures).

I have taken — Dim iValue As Variant, please let me know if it is right for all the string or long integer, numeric values.

Please Login or Register  to view this content.

Thanks in advance!

Have you looked at the .Row or .Column properties of a range object?

Please Login or Register  to view this content.

I've just written above codes on best of my knowledge. Please let me know if anything is beyond; is for my learning.

snb — Thank you for your quick reply! yeah First I need to recognize the Row and Column number (address) individually, then I have to pass (assign) those values on the respective ActiveSheet.Cells(Row, Column).Value. plz see my method of using them for further actions.

It looks like you might be interested in the .EntireRow and .EntireColumn properties.

Thank you snb and mikerickson,

Please see below codes, hope now I think it is more understandable for you from my side ...and help me out more. I have just edited your codes; and see now it's working fine for me.

Please Login or Register  to view this content.

..just one question that If I don't find any search value output then how can I Exit Sub with a MsgBox "Searched value or text not found.", vbCritical??
B'cuz if I don't enter any value/ text or click on 'Cancel' button of the InputBox, then also the codes run, and sometime runs at a wrong column. Please look into this matter and help me out.

Thank you so much mohd9876, snb, mikerickson

It works fine, now this thread is solved. You guys are awesome!!

Thanks again.