Name a cell

Question

Goodnight,

I am making a rule in vba that will run for all worksheet lines. So I created a variable, Cells(l,3) = "ID", but when I call this variable in the formulas is returning the word ID instead of the value in the cell (L,3).

Can someone help me?

Answer 1

Via VBA

Dim r As Range
Set r = Range("E2")
r.Name = "ONomeDaCelula"

Alternative via Excel Interface

Open the context menu of the cell you want to set a name. You can do this by right-clicking:

Set the name of the dialog box:

To test, Enter a value in the cell

Select any other cell and invoke the value by the quick formula input. In this case it is =foo

With this you will have the expected result