Tom,

Thanks for your help, I meant that the value in T1 was the total number
of rows I needed, so when I was applying it to the copy range I was
getting 1 row too many. When I was reading your solution I had a
brainwave (which for me was more of a brainripple!) and adjusted the
destination range in the original solution from 'T6' to T5' thereby
including the first cell and getting the correct number of rows.

I appreciate your help.

Regards,
Jaime.


--
jaimetimbrell
------------------------------------------------------------------------
jaimetimbrell's Profile: http://www.excelforum.com/member.php...o&userid=26162
View this thread: http://www.excelforum.com/showthread...hreadid=511609