Subtract range via vba

[tantcu]

Hello,

I'm working on the code that use value from E16 to E46 from workbook 1 subtract value E16 to F46 from workbook 2 return value at G16 to G46 from workbook 2.

G16(worksheet2)= E16(worksheet1) - E16(worksheet2)- F16(worksheet2) and the formula extend to G46

This is my code and it did not work

Worksheets("Second Pull").range("G16:G47").Value = Worksheets("First Pull").range("E16:E47").Value - Worksheets("Second Pull").range("E16:E46").Value

Please help

Thanks

[AB33]

I am not 100% sure, but you can only add individual cells, not a range.