Cell Values

HI,
I'm stuck on something here. I have a custom made program that places data into an excel file. I want to do a find on a certain text in a column- i know how to do this bit with vb code, however when you do do this it kinda activates the cell that that text is in then if you press the down arrow in excel it will move to the row below it....well my problem is that i want to return the row value and column value that the find feature bought it to, for example i do a find on "99/000" it finds it on row 567 col 1, i want my code to be ActiveSheet.Cells(row,col).Select where as the row and col values are what has been selected.....any idea how to do this?

Thanks

you'll have to be a little bit more clear as to what you need, steve. Best guess:

If the cell you want the location for is selected then you can access the activecell.column or activecell.row to get the location.