View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
willemeulen willemeulen is offline
external usenet poster
 
Posts: 27
Default current row in formula

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