MSDN > Home page del forum > Visual Basic for Applications (VBA) > Need a function that places a string to a cell
Formula una domandaFormula una domanda
 

DomandaNeed a function that places a string to a cell

  • giovedì 9 luglio 2009 21.07motorway Medaglie utenteMedaglie utenteMedaglie utenteMedaglie utenteMedaglie utente
     
    I need a function that places a string parameter to a cell. But the string must have the following properties: the names of Excel cells' names must be interpreted as their names, not as simple text, so I can move this cell for autocomplete multiple cells, and also when some cells delete/add -> names of cells in this parameter must change too. For ex., F(A1+3; B2=5) places A1+3; B2=5 to this cell. Also it must autocomplete and change to for ex., B1+3; C2=5 when adding a column etc.
    How can it be implemented?
    Guru, help!

Tutte le risposte