What about a function in VB? i.e. Concatenate_Range(First_range,
Second_range) returning an array with all the data (of course I don't know
how to write it, yet).

"N Harkawat" wrote:

Not unless you can in a separate area pastelink these non-contiguous ranges
into a single contiguous range.

"GaryF" wrote in message
...
The data I wish to perform IRR calcs on is in different ranges in the
worksheet. Is there any way to concatenate these ranges so they appear to
IRR
as one contiguous range?