Rune daub,
range("A" & activecell.Row).Activate
John
"Rune_Daub " wrote in message
...
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/