=20*INDIRECT(ADDRESS(ROW(),COLUMN()+1))

or

ActiveCell.FormulaR1C1 = "=RC[1]"

--
Regards,
Tom Ogilvy



"gareth jax" wrote in message
ups.com...
Hello,
I'm using the web query function inside Excel 2003 to import tabular
data generated by a php file (also done by me).

I'd like to place some formulas inside the table generated by php and
up to now, i've been able to write directly to it and successfully
place those formulas inside my Excel document.

eg: "=20*A1" works perfectly and it's executed flawlessy in excel.

I need to go one step further: i need to create "relative positioned"
formulas inside the php, for example "[myposition+one column to the
right]".

Is that even possible in excel ?

Thanks in advance for any hint!