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?