Good Night,
I'm making a rule in vba that will rotate to all rows in the worksheet. So I created a variable, cells (l, 3)="ID", but when I call this variable in the formulas it is returning the word ID instead of the value in the cell (L, 3).
Can anyone help me?
Dim r As Range
Set r = Range("E2")
r.Name = "ONomeDaCelula"
Open the context menu of the cell you want to define a name for. You can do this by right-clicking:
Setthenameofthedialogbox:
Totest,enteravalueinthecell
Selectanyothercellandinvokethevaluebythequickformulainput.Inthiscaseitis=foo
Thiswillhavetheexpectedresult
