title: How to assign a name to an Excel cell using VBA?
body: <p>I need to assign a unique name to a cell which calls a particular user defined function.</p>
  
  <p>I tried</p>
  
  <pre><code>Dim r As Range
  set r = Application.Caller
  
  r.Name = "Unique"
  </code></pre>