My fault, the formula was missing a parenthesis. Fixed that and it worked
fine for me...

=OFFSET($B$55,0,7*(ROW()-ROW($X$3)))

HTH


"Laistra" wrote:


Typed it into X3 and it says the function has faults: $B$55,0,7
In that area, and refuses to accept it keeping that part highlighted.
Excel 2003 :S

Thanx for trying to help:)

Huggs

Laistra


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