Hi BeefNoodleSoup
I'd guess a "For Each" loop.
Option.Explicit
Dim rng as Range
Dim name as Range
Set rng = (some range of cells - you fill in the blanks)
For each name in rng
     Application.Goto rng True
     ' Take some other action
next name