Can anybody help me create a 'join' between to non-contiguous ranges
to feed into 'Slope'?

I saw another question about this on this forum BUT my problem is that
the ranges are variable, using offset, rather than fixed.

Want I want to do is:

Slope(join(offset(a10,0,0,1,a1),offset(b10,0,0,1,b 1)),'known_x's etc)

Any help appreciated,

Lawrence

Actually Patrick I want a worksheet version... not VBA

Thanks for your help though,

Lawrence





"Patrick Molloy" wrote in message ...
UNION

eg
SET rTarget = UNION(RLeft , rRight)

Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
Can anybody help me create a 'join' between to non-
contiguous ranges
to feed into 'Slope'?

I saw another question about this on this forum BUT my
problem is that
the ranges are variable, using offset, rather than fixed.

Want I want to do is:

Slope(join(offset(a10,0,0,1,a1),offset
(b10,0,0,1,b1)),'known_x's etc)

Any help appreciated,

Lawrence
.