>>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.
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++