Moving relative
 

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/

Moving relative
 

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/