OK

why do you want to increment the row number ? Have you added another row of
data ? And you just want the last one ? If so, are there any gaps in
column H ?

Regards

Trevor


"FIRSTROUNDKO via OfficeKB.com" <u15639@uwe wrote in message
news:74607e218d598@uwe...
Hi

Range A1 has the formula ='[apples.xls]Adjustment'!$H$44/1000

but evereyday i want to update the formula by the next H Cell

i.e tommorow I want the formula to read

='[apples.xls]Adjustment'!$H
$45/1000

and the next day

='[apples.xls]Adjustment'!$H
$46/1000

Thanks in advance

--
Message posted via http://www.officekb.com