Search macro to look for a defined range name

[bubbafish]

Trying to find the code in my search macro to look for a defined range name. In the case below I have a cell in the worksheet with the name of “Active_Index” and it = 27
So the macro below will find the value of 27 if it is hard coded. How do I modify it so it looks for a value from a cell in the worksheet called “Active_Index”

Sub Find_Index()
'
Application.Goto Reference:="INDEX"
Selection.Find(What:="27", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
End Sub

 

[gallen]

Just make the value what is in the named range:

What:=[Active_Index].Value

 

[bubbafish]

Excellent! Many Thanks!