this is the disadvantage that doesnt work for me here,becaouse i want
to use replace function of the windows and place a formula based on
the current cell and the problem is that if i move to another cell,it
will autoticly update all the cells with the current one
any bypass to this problem?

JE McGimpsey :
Yup. Again, same behavior (need F9, updates on other sheets). May work
for OP...


In article .com,
Lori wrote:

or just:

=CELL("row")