VBA for referencing ranged variable name

[helpneeded2]

I have very little understanding of VBA and am trying to modify some existing code.

The cell in C9 of my sheet contains a file name reference.

The current code has 3 references to C9:

path_ = ThisWorkbook.Worksheets("Settings").Range("C9").Value
ThisWorkbook.Worksheets("Settings").Range("C9").Value = 0
ThisWorkbook.Worksheets("Settings").Range("C9").Value = .SelectedItems(1)

Ideally I just want to set C9 to a variable, so that I only have to change the reference in 1 area if needed.

I have tried a couple different ways, but cannot get it to work due to my limited understanding of VBA.

Could someone please advise if this can be done, and how?

This was what I last tried that did not work:

Dim fileLocation As Range
fileLocation = ThisWorkbook.Sheets("Settings").Range("C9").Range

path_ = ThisWorkbook.Worksheets("Settings").fileLocation.Value






This results in an error

 

[rlv01]

Ranges are objects so a 'set' statement is required for variable assignment. It works like this

    Dim fileLocation As Range
    
    Set fileLocation = ThisWorkbook.Sheets("Settings").Range("C9").Range
    
    path_ = fileLocation.Value
    fileLocation.Value = 0
    fileLocation.Value = MyFileDialog.SelectedItems(1)

 

[John_w]

This was what I last tried that did not work:

Dim fileLocation As Range
fileLocation = ThisWorkbook.Sheets("Settings").Range("C9").Range

fileLocation is a Range variable, which is an Object, so you need to use Set:

Dim fileLocation As Range
Set fileLocation = ThisWorkbook.Worksheets("Settings").Range("C9")

Note - you don't need the .Range at the end.

 

[helpneeded2]

Thank you for your help @rlv01 and @John_w, I have got it working as desired now.