I'm not really sure what else to suggest for this one. The dollar ($) signs
in the cell reference should make it an absolute reference (apologies if you
know all this already), so that if you copy the cell down to the one below,
the row number remains the same. XL should not change the reference to $B$56
if you copy down to the cell below. Perhaps the hungarian version uses a
different symbol to indicate an absolute reference?? Try typing the cell
reference without the $ symbol and then pressing F4 to change it to an
absolute reference. Does it use the same symbol?

Other than that you could try using the INDIRECT function to fix the
reference at B55. Instead of $B$55 in your formula, use INDIRECT("B55"). This
fixes the reference as a character string and then INDIRECT makes it into a
reference.

Hope you get it working.


"Laistra" wrote:


Well I copy paste and does not accept it. If I change it to OFSZET (that
is the same function in Hungarian = I am Hungarian so is my excel) then
it accepts BUT not with , only ; (in help I see function description
using it). It is possible that some things give #name for various
regional settings but I tried both your version and the hungarian
equivalents and still gives #name:S I dunno why.

Putting OFSZET($B$55) into X3 already gives me the value of $B$55 np..
if I do.. ahmm OFSZET($B$55;0;7) that also works BUT.. if I copy it
down it won't change the B into the +7 one but will do $B$56 :S

Laistra


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