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

Please Login or Register  to view this content.

Please help

Thanks

[AB33]

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