Thx!

"Union" was new to me

Anyway's got it working like this

Code
-------------------
Set myrange = Union(Worksheets("Chart").Range(Cells(startx, column), _
Cells(weekx, column)), Worksheets("Chart").Cells(55, column)
-------------------


Cheers

--
jop
-----------------------------------------------------------------------
jopu's Profile: http://www.excelforum.com/member.php...fo&userid=1662
View this thread: http://www.excelforum.com/showthread.php?threadid=31485