Re: global cell arrays ?

Hello bluelagoon,

it might be easier than you think or I didn't understand your problem
at all ;-)

Try this in your function:

....
global my_cell;
my_cell{1} = 'whatever';
....

Then in another function you can use this code:

....
global my_cell;
dummy = my_cell{1};
....

The command 'global' will produce an empty variable when there isn't
a global variable with the desired name. But in Matlab you can just
overwrite this variable with a cell or whatever kind of variable you
want.

Tiga
.

Relevant Pages

  • Re: Insert Text When Blank
    ... Each cell can contain a formula or a value--but not both at the same time. ... will have to overwrite them to enter the real value. ... Chuck N wrote: ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Formulas
    ... (they will overwrite each other). ... Your result will have to be in D4 or some other cell - the formula ... wjohnson's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29640 ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: If Value is > 0, in a named range ??
    ... I see how you were checking for the cell count in the named range. ... If MsgBox("Do you want to overwrite last week's bills?", ... For Each c In Sh2bwWV ...
    (microsoft.public.excel.programming)
  • Re: Conditional Formatting - to highlight overwritten formulas
    ... If you can't define what may be put in the cell, just leave Any Value selected in Data Validation, and use an Input Message as your warning when they select the cell. ... overwrite the formula ... > experienced contributors to the spreadsheet to realise that they have ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Conditional Formatting
    ... There are many Solution like Protect Sheet and Data Validation ... "Hardeep Kanwar" wrote: ... Means if Some one overWrite the Cell it Change the Font Color. ...
    (microsoft.public.excel.worksheet.functions)