Moving relative

  • Thread starter Thread starter Rune_Daub
  • Start date Start date
R

Rune_Daub

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
 
Back
Top