=INDIRECT("A"&ROW())*INDIRECT("B"&ROW())/INDIRECT("C"&ROW())
--
David Biddulph

"willemeulen" wrote in message
...
How do I use a reffer to a current row in formula

Example:

A1*B1/C1

A&Row()*B&Row()/C&Row

The example above doesent work but want column to be fixed and row
depending
on the row it's actully is current. I want to formula to be working when I
copy it from one sheet to the other.


Cheers,

w