The code for sum is not giving correct output, help require

[mso3]

Hi friends,
I want to sum the following columns:

A … B … A+B
Columns: d+e = F
Columns: J+K = L
Columns: P+Q = R
Columns: V+W = X
Columns: AB+AC = AD
Columns: AH+AI = AJ
Columns: AN+AO = AP
Columns: AT+AU = AV
Columns: AZ+BA = BB

The code is working fine without error but it is adding the columns ‘d and e’ for all subjects. I want the sum of each particular subjects in their A+B column mentioned above.

Please suggest me a correction.

Thanking you.

[jewelsharma]

delete the following line from your code, and then see if it works alright.

Please Login or Register  to view this content.

[mso3]

Hi Jewel Sharma,
Thank you. If I delete the line then the macro is working fine but I want to change formula to value. So how to achieve it?

Thank you.

[mso3]

Hi Jewel Sharma,
Thank you. I inserted the following lines in the code and it's working fine.

Please Login or Register  to view this content.

The cell range for each column is different. It's only a sample code.

Thank you for the assistance.