Good time to learn. Turn on the macro recorderselect the
rangeEDITfind
clean up the macro. Post back with additional needs.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Fan924" wrote in message
...
I need a macro to search a column of 20 cells. When it find the number
I am looking for, I need it to return the cell address it is found in.
Thanks