Macro to scrol to a name in a cell but with screen slit using freeze panes

[tonywatsonhelp]

Hi Everyone,

Hope someone can help me.

I want to be able the have a macro scroll the page to a name.

Now heres my page set up

Columns A to H are fixed using freeze Panes,

I onwards are the columns with names in,

The name I want to scroll to is in cell B5 (as in this is where the name is stored to look for)

the names are listed in row 8

So I need a macro that can look at the name in cell B5, go along Columns I to CA
find a matching name and scroll that column so it sits next to my frozen cells, so next to H.

can someone help me do this please?

Thanks

Tony

 

[FormR]

Hi, you could try something like this:

Sub M()
Dim r As Range
Set r = Rows("8").Find(What:=Range("B5").Value, LookIn:=xlValues, LookAt:=xlWhole)
If Not r Is Nothing Then Application.Goto r, True
End Sub

 

[tonywatsonhelp]

Thank you FormR,

This is exactly what I wanted

Tony

 

[FormR]

Great, good to hear

I did miss one the parameters though, I think you should include the red section, set to TRUE if appropriate.

Sub M()
Dim r As Range
Set r = Rows("8").Find(What:=Range("B5").Value, LookIn:=xlValues, LookAt:=xlWhole, MatchCase:=False)
If Not r Is Nothing Then Application.Goto r, True
End Sub