Find Cell position in the column based on the value

I need a macro to find the possition of a cell using a value.

probably when i give a cell value to macro it should search in the range of list and should return the cell possition.


could you please get me this code.

How do you

give a cell value to macro ?

Are you prompted with a message box to input the value? What is the search range? Is it the whole sheet, a row, a column or another range? If you could attach a copy of your file, it would be easier to help.

i will give value using a message box and i will search only a column to until the end of the column.

will this information be enough for the code?

inthe same code how can i get the address of the previous column say C as per the below code

Originally Posted by kbkumar

Perhaps something like this:

Please Login or Register  to view this content.

Hello kiran527. Give this try. The code assumes that your data is in column A and that your first row has column lables.

Please Login or Register  to view this content.

Can i get the address in Cell(2,2) format
is it possible???

What column is your data in?

This will give you the address of the cell to the left of the value you input assuming your data is in column D.

Please Login or Register  to view this content.