Jump to specific column from dropdown menu

[besis]

Hl,

I would like to scroll to specific column by matching the value of cell criteria from drop down menu.

I used this to do matching for the rows.

Please Login or Register  to view this content.

My question is that how I can modify this for the column (see atachment)?


D2 cell contains dropdown menu with data G4:AZ1

I would like to make this work so if I select from dropdown menu P5 it would scroll to column K

Thanks for any help I can get.
B.

[protonLeah]

col= Application.Match(Range("d2").Value, Range("4:4"), 0)

then
Application.Goto Cells(somerow,col), True

[besis]

Hi,

My code looks like this.

Please Login or Register  to view this content.

It didn't work for me. I alm probably doing something wrong.

Thanks for helping.
B.

[jindon]

Change to

Please Login or Register  to view this content.

[besis]

Hi,

This is working. Thank you and protonLeah for helping.

All the best.
B.