Microsoft Developer Network > Domovská stránka fór > Visual Basic for Applications (VBA) > Need a function that places a string to a cell
Odeslat dotazOdeslat dotaz
 

DotazNeed a function that places a string to a cell

  • 9. července 2009 21:07motorway Uživatelské medaileUživatelské medaileUživatelské medaileUživatelské medaileUživatelské medaile
     
    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!

Všechny reakce