Multiple "Range" with "Cells" property?
 

Thx!

"Union" was new to me :rolleyes:

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

Multiple "Range" with "Cells" property?
 

Hi jopu

See Jurgen his warning



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


"jopu" wrote in message ...

Thx!

"Union" was new to me :rolleyes:

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

Multiple "Range" with "Cells" property?
 

Ron,

Jopu might not know who Jurgen is ;)

Jopu,

it's me..and DO read my earlier warning!


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Ron de Bruin wrote :

Hi jopu

See Jurgen his warning

Multiple "Range" with "Cells" property?
 

Jopu might not know who Jurgen is ;)

Oops



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


"keepITcool" wrote in message ft.com...
Ron,

Jopu might not know who Jurgen is ;)

Jopu,

it's me..and DO read my earlier warning!


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Ron de Bruin wrote :

Hi jopu

See Jurgen his warning