Hello Steve,

I can't see how it can work in XL 2010.

It fails probably because you're not specifying any column letters, just the row refs.

But why not simplify things by defining a dynamic range name in the Excel App. which automatically adjusts to the amount of data in the AllParts tab, then use the range name in your formula rather than worrying about which are the first and last rows.