Excel macro to loop through a particular column

QuestionEdit

can you please help me in figuring out the solution for my problem.

My problem is to loop through a particular column say for eg "State" upon finding the specified state(eg.IL) i need to get the row number of the corresponding cell.

Reva

AnswerEdit

Reva

Sorry I am not a macro expert and I have no idea how to include your need in a macro. I suggest you reask the queastion of another allexperts person and check the resumes for macro expertise. I'm sure you can find someone who will get you a good answer.

Sorry I couldn't be of more help.

Richard