Say that you have an excel sheet with with columns A to K and 1000 rows
in it.

I have a search function that activates a cell, when the result of the
search is found. For example Cell J243.
Now I want it to automaticly activate Cell A243.

How do I make it go to column A in a row, no matter from what column it
originated at the end of the search.

Examples:
J243 -- A243
C852 -- A852

Thx from the n00b

Rune daub


---
Message posted from http://www.ExcelForum.com/