Worksheet version of VBA JOIN

L

Lawrence

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
 
L

Lawrence

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

Thanks for your help though,

Lawrence
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
ListObjects - VBA code that worked in previous versions of Excel doesnot work in Excel 2013 0
Selection of range for the 'slope' function 1
Naming non-contigent cells with vba 5
UDF returns different result in worksheet to that in VBA 6
Referring to ranges as Cell, Range, and variables 6
Filesearch in 2007 1
first sip of working with range in vba excel 6

Top