title: VBA Assign a value to a cell inside a function?
body: <p>Is there anyway that I can assign a value/name to cell within a function ?</p>
  
  <p>Thank you</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Sorry for being unclear, here is my requirement.</p>
  
  <p>I'm having a user defined function (=MyFunction()) which can be called from a excel sheet. Thus, I also having a menu button where I need to recall the all the functions calls to =MyFunction(), when user click a the button.</p>
  
  <p>My plan is to inside the MyFunction(), assign a name rerefence to the calling cell and store it inside vba. So I could have a array of cell names. Then I can recall these cell references when the menu button is clicked.</p>
  
  <p>Please help me to achieve this. Is there a any better way of keeping cell references ?</p>