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.

Sub year2019()
If AU8 = 2019 Then
ActiveWindow.ScrollColumn = 99
    Range("cu9").Select
End If
End Sub

Thanks for any help I can get.
B.

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

Use

If Range("AU8") = 2019 Then

**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