Is there a way to index a named range like an array? For example, in a spreadsheet I name cells F1 to F5 as "DaRange" and in VBA I want to set the second element (which is F2) to 5. Is there a way to do the following?

Range("DaRange")[2] = 5

Thanks