Spreadsheet and programming

[cyrille de brébisson]

Hello,

I am not 100% sure that I understand what you are trying to do, but here are some pointers

Have you looked at the Cell command? It allows you to access Cells by their row/column number (Cell(1,1) <=> A1, Cell(0,1) is column A)

You can do A1:AA100(-1):=Cell(0,0) to erase the spreadsheet.
It basically sets all cells content and meta data to the value of Cell(0,0), which is a special 0 which is detected as an empty 0 by the spreadsheet.

Cell(0,1):='Row'; Cell(0,2):='BINOMIAL(20,0.2,A:A)'
might do what you want...

Cyrille