Recorded Macro - Defined Name Question

[JUDYT]

Below is part of a macro that I recorded and it does work. The problem is I don't understand why it works and since I often work with macros (simple ones) I would like to understand them. The part I don't understand is where I add the name. At the very end it says C7:C14" This not the range I highlighted when recording but it works. When I change the range to the actual range it does not work. Does the C7:C14 stand for something other then the actual range. This is the second macro this has happened on. The actual range is N2:G937

Just Curious


ActiveWorkbook.Names.Add Name:="Notes", RefersToR1C1:= _
"='[serviceover45-current.xls]Sheet1'!C7:C14"
Range("N2").Select
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-7],notes,8,0)"
Range("N2").Select
[N2].Copy Range("N3", Range("M65536").End(xlUp).Offset(, 1))
Range("A2").Select

 

[Oaktree]

You have RefersToR1C1 but a relative address. Try
ActiveWorkbook.Names.Add Name:="Notes", RefersTo:= _
"='[serviceover45-current.xls]Sheet1'!$N$2:$G$937 "

With "RefersTo" instead of "RefersToR1C1"