#NAME error is because XL does not recognise the function. Make sure there
are no typing errors in your cell, the function name should be OFFSET. Don't
know very much about effect of using different seperators either.

"Laistra" wrote:


Nope still not works. Firstly if I not type ; in stead of , it never
accepts the value into the field at all:

=OFSZET($B$55;0;7*(ROW()-ROW($X$3)))

I guess for it being due to not being English myself.. perhaps.
Different separators?

But when i did that it still gives #name, checking how come it refers
to arrows existing already, circular or recursive linking.


You said yours works, could you send a working excel sheet where this
function does the wonder to me perhaps? So I can check how come it does
not implement it in mine?

Thanx

Laistra


--
Laistra
------------------------------------------------------------------------
Laistra's Profile: http://www.excelforum.com/member.php...o&userid=28731
View this thread: http://www.excelforum.com/showthread...hreadid=484215