Hi Golf,

I may have missed the point here but looking at the attempts and the recorded macro i would say the issue could be:

n has been defined as long and holds a row number, this means that when n is in the refers to section n may be the number 2.

You could use n as part of the reference for the naming of a range as below:

Sub test()    
    Dim n As Long, InstalDesc As String
    n = 3
    InstalDesc = "Dave"
    
    Worksheets("Task List").Names.Add Name:=InstalDesc, RefersTo:=Range("A" & n)
End Sub
The above will name range A3 as Dave

Hope this helps