>>>HI
>>>
>>>I want to write formulae into a range of columns. Can I use a numeric refernce to excel columns or do I have to work out the cell reference like AA,AB etc
>>>
>>>Thanks
>>>
>>>
>>>Nick Mason
>>
>>
>>Its ok
>>
>>I can see I can use the R1C1 format to reference cells.
>>
>>well done
>>Nick
>>Thanks Nick
>
>
>Hi there :)
>
>If you have complex exports to excel (writing in predefined cells)
>You can have look at my rep2excel tool here in downloads.
>

I'll take a look at that thanks.

Nick
>Among the other things, you can write precisely to excel templates using 3d positioning system - nSheet,nRow,nCol
>
>so using calls like like ;
>
>oXl.make_cell(1,25,5,'EasyExport')
>oXl.table_in_section(1,27,5,'myAlias')
>
>you can relatively simple accomplish very complex exporting tasks.
>
>Rgds++