Excel Row/Column Jumping

[Chaozfate]

Dear All,

I have this excel whereby the rows and columns have quite a length of data.

Example:

	column AA	column AB	column AC	column AD
Row 1	AA50	AA51	AA52	AA53
Row 2223

My row 1 consist of product code.

I wonder if there is any macro or a method to fullfill my request below:

Lets say I am currently at Column AA Row 2223, I wish to jump to the column AD but maintain at Row 2223.

How I did it, is highlight the whole Row 1, and CTRL F the product code, but this will trigger excel to jump straight back to Row 1 due to my search result, this is very inconvenient cause I need to scroll all the way back to Row 2223.

Hope there is anyone out there would be able to provide advise/help to my little inconvenience.

Thanks and regards,
CU

 

[Peter_SSs]

that any cell will do for the double-click.

Hmm.., perhaps that wasn't as clear as I meant it to be but you have probably figured out anyway: Any cell will trigger the code but the target cell is determined by whatever cell is double-clicked.
So if Z100 is the active cell and you double-click any cell in row 105, you will be jumped to the relevant column in row 105, not 100. So if you want to stay in the same row as the active cell then you need to d-click any cell in that row.