Change it to

=IF(INDIRECT("'"&ROW(A47)&"'!$B$1"<0;INDIRECT("'" &ROW(A47)&"'!$B$1;" ")

and copy down


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bart" wrote in message
...
Hi,
This formula has references to other sheets in the same file.
I have this formula in A1 : =IF('47'!$B$1<0;'47'!$B$1;" ")
I have this formula in A2 : =IF('48'!$B$1<0;'48'!$B$1;" ")
and so on and so on.
I want to copy this formula in about 50 rows. So i tried to click it and
move it to others cells. But the formula stays the same. I thought the
numbers 47 and 48 should increase with 1, but they don't.
How could I solve this ?

Bart