VBA - name of selected cell.

[bshawn]

I'm sure this is a simple question. I have a spreadsheet containing columns of data. I need a macro that can search for a specific word, and then return the location of the cell where it finds it.

For example, if the column heading CustomerID is located in "D5", then If I search for "CustomerID", I want it to put "D5" in a specific cell on another tab of the workbook. The column names are always the same, however, their location can move, so I need to be able to reference the name of the cell where the information is at.

It would be even better if it could input the name of the cell where the CustomerID from the first record is located, and not where the name "Customer ID is located (one cell below the name), but I think I can make either way work.

Thanks.

[StephenR]

Does this do what you want?

Please Login or Register  to view this content.