Jump to specific column if cell contains value 2019

**besis** · 01-17-2019, 09:12 AM

Hi,

If the cell AU8 contains value 2019 I would like the cursor to jump to column 99 and after select the cell CU9

Trying this code with no luck.

Please Login or Register  to view this content.

Thanks for any help I can get.
B.

**YasserKhalil** · 01-17-2019, 09:14 AM

Use

Please Login or Register  to view this content.

**besis** · 01-17-2019, 09:18 AM

Hi YasserKhalil,

Thanks for the fast reply. It works.

All the best.
B.

**YasserKhalil** · 01-17-2019, 09:20 AM

You're welcome. Glad I can offer little help

**besis** · 01-17-2019, 09:38 AM

Hi,

Can this work if the cell AU8 is a dropdown with different values.
If I change the value so it goes to specific column?

All the best.
B

**YasserKhalil** · 01-17-2019, 10:00 AM

You can put your code in Worksheet_Change event so as to put all your possible conditions and values and their related columns

**besis** · 01-17-2019, 04:56 PM

Hi,

You are right, after puting the code in Worksheet_Change event it works.
Thanks again.

All the best.
B.

**YasserKhalil** · 01-17-2019, 05:06 PM

You're welcome. Glad I can offer little help

Re: Jump to specific column if cell contains value 2019