Help Adapting Code To Assign A Named Range To Just A Variable

[Ark68]

Someone helped me create this line of code to assign a name to a range.

Workbooks("Sports17.xlsm").Names.Add Name:="data_file_list", RefersTo:="=OFFSET('[" & wb_sched.Name & "]" & temp_ws.Name & "'!$B$1,1,0,count('[" & wb_sched.Name & "]" & temp_ws.Name & "'!$A:$A),2)"

Instead of assigning this range to a named range, I want to assign a variable to it. I am hoping someone can assist in adapting this code appropriately.

Dim rdfl as range
Set rdfl = OFFSET('[" & wb_sched.Name & "]" & temp_ws.Name & "'!$B$1,1,0,count('[" & wb_sched.Name & "]" & temp_ws.Name & "'!$A:$A),2)

I know my interpretation is incorrect (in red above) as I'm receiving a syntax error.

 

[Jerry Sullivan]

Are you wanting to store a static reference to the range that results when VBA evaluates that expression?