SUM offset ranges in a loop

Hi,

I have a table that fills in using loops through different data. The data all fills in ok but I can't get the sums to work for the totals columns. I am trying to loop through each cell in the total row and sum the range above using offset but I keep getting the Method 'Range' of object '_Worksheet' failed error. Please could someone tell me how I should be setting this range up. Table and code below:
Capture.JPG

Please Login or Register  to view this content.

I would just use the sum function in the cell but I will be running another rub to re fill the table with currency data from different sources so i'll need to update the formats.