union with multiple sheets
 

hi

anyone know a way of creating a union between ranges from 2 sheets??
because i have just found that union won't work as normal if you tr
this...

thanks

Jimmy

--
jimmy
-----------------------------------------------------------------------
jimmyp's Profile: http://www.excelforum.com/member.php...fo&userid=3221
View this thread: http://www.excelforum.com/showthread.php?threadid=52967

union with multiple sheets
 

The hierarchy is Book then Sheet then Range. A book contains sheets. A sheet
contains ranges. Just as one sheet can not span 2 different workbooks (which
somehow seems obvious), a range can not span two different sheets (which does
not seem obvious). That is just the way it is...
--
HTH...

Jim Thomlinson


"jimmyp" wrote:


hi

anyone know a way of creating a union between ranges from 2 sheets??
because i have just found that union won't work as normal if you try
this...

thanks

Jimmyp


--
jimmyp
------------------------------------------------------------------------
jimmyp's Profile: http://www.excelforum.com/member.php...o&userid=32217
View this thread: http://www.excelforum.com/showthread...hreadid=529673