errr. Nevermind I found the solution myself. For anyone intereste
it's as follows.

Worksheets("wSheet").Range("X105:X109").Value = _
Worksheets("Bubble").Range("L4:L8"

--
goobe
-----------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...fo&userid=1983
View this thread: http://www.excelforum.com/showthread.php?threadid=47669