Macro for Sum of Cells

[angeleenmc]

I need a macro to add cells. For example Cell Z9=Sum(I9:X9).

It would calculate until that last row of data.

Thank you!

[Kaper]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[gmr4evr1]

Removed duplicate post

[Arkadi]

Could try this, but guessing a bit since there was not a lot of detail in your request.

Please Login or Register  to view this content.

[gmr4evr1]

You might have to elaborate a bit more. If I read this correctly, you want Z9 to show the sum of I9 through X9? If so, put exactly what you have =SUM(I9:X9) in cell Z9. Not quite sure what you mean by "It would calculate until that last row of data."
If you want it to Sum each row after that, just click in cell Z9 and drag down the formula for the other rows in column Z.
Forgive me if I am wrong in my thought process.....it's usually what happens with me on here