Not sure if anyone else has come across this.
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...