VBA- FileDialog Named range

[Miya]

Hi, i have a named range "rngImportDeliv" which is the file path to where the file is stored. How can i incorporate this named range with the below code?

 Dim fd          As FileDialog
     
    Set fd = Application.FileDialog(msoFileDialogOpen)
    If fd.Show() = True Then
         Set sourcebook = Workbooks.Open(Filename:=fd.SelectedItems(1))
    End If

 

[Tom Urtis]

Your question is confusing. A named range is a range (for the most part), and a file path is a string. A range can hold a string but it cannot *be* a string. Whatever you are doing should be clarified.

 

[Ruddles]

Is rngImportDeliv a single cell?

What is its value?