"Living the Dream" wrote:
When using vba to set certain values within an array of
values to which I am using SumProduct to draw specific
data from, if fails to calculate.

If I enter the values manually, it works fine; any thoughts
as to why there is an issue between vba value pasting and
manual entering...

My thoughts a we need to see a concrete example.

WorksheetFunction.SumProduct works just fine in VBA, if you use it
correctly.

The last condition is the key. You probably misunderstand how to use
WorksheetFunction.SumProduct.