Hi jopu

See Jurgen his warning



--
Regards Ron de Bruin
http://www.rondebruin.nl


"jopu" wrote in message ...

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!


--
jopu
------------------------------------------------------------------------
jopu's Profile: http://www.excelforum.com/member.php...o&userid=16621
View this thread: http://www.excelforum.com/showthread...hreadid=314859