SUMPRODUCT calculation in VBA

Hi to all dear MSEXCEL experts..

First of all... Sorry for my english... It's poor

I'm new in this forum.. and i need some help about the sumproduct function in VBA.

I try to explain better my situation.

SHEET(1)

COLUMN B => Nation
COLUMN E => PRODUCT LINE
COLUMN F => TURNOVER

SHEETS(2)

Cells(a2) => Nation (dinamyc cell, linked to a combobox with all the PRODUCTLINE)
COLUMN B => PRODUCT LINE
COLUMN C => TURNOVER

Well.. In sheets(2), cells(B6), the formula

Please Login or Register  to view this content.

work fine.. But it's very slow for various reason...

So i need to calc the sumproduct in VBA and then write the result in cell(B6)...

but i've got some difficult wrting VBA code...

i try this (RAFF is sheets(1) and RIEP is sheets(2))

Please Login or Register  to view this content.

But i receive an error..

Any ideas??

I suggest you use a key column in your raff table instead of code

also if you can sort your raff table by country code first you can improve the formula efficiency by limiting the ranges it has to look at