Combo Box to Filter by Merged Column Headers

Hello All

Wishing you all a Prosperous New Year!

I have a sheet attached which displays a list of company names as merged column headers. I have frozen the panes between E4 so the company header names and products in columns A:D are always visible upon scrolling. The company header names start at column E and go right through to column BV. This is a pain when trying to search for a certain company header as means lots of manual mouse scrolling. I know that if I use Excel built in ‘find’ function and specify a company name, Excel will locate and move the column right where I want it to be (which is column E4 as mentioned above) . However, using the built in ‘find’ function only works for exact matches.
What I would like to do is create a combo box that acts as a dymanic search, so as I start typing in the box, it shows all of my column headers as a list and begins to filter down that list as I complete typing, until I have my exact match. Then (like the built in ‘find’ function) will display my column result.
I know this is possible when using rows but I have no idea how to do this by columns, let alone merged ones.
Could anybody help with this?
Many thanks
G1

Originally Posted by davesexcel

Check it out.

Private Sub ComboBox1_Change()
Dim fRng As Range
Set fRng = Range("D2:BV2").Find(what:=Me.ComboBox1, lookat:=xlWhole)
Application.Goto Reference:=fRng, Scroll:=True

End Sub

davesexcel, that is exactly what I was looking for. Thank you so much. Can I ask how did you get to do it so quickly? I've been using excel on and off for years and I still cannot get passed the VBA basics, just can't seem to progress. You have saved me a lot of heart ache. Legend....and Happy New Year