Hi Biff,

You are quite correct. The problem now is, is that my information in
3DBC only starts on line 10 in the original file, and has to be
displayed in line 10 in sheet "Short". But I dont know how to change
the range to display it correctly. Can you help with this?

Thanks.
Sonar


--
sonar
------------------------------------------------------------------------
sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
View this thread: http://www.excelforum.com/showthread...hreadid=399751