How to sum the cells left of the active cell

[ahilty]

Hello,
I am trying to sum the four cells to the left of the active cell. Each time the macro is run, the active cell is different depending on user selected material so I cannot reference a specific cell.

Any ideas (I'm sure it's not that difficult)?

Thank you

[JOHN H. DAVIS]

Without know where the output would go, this would place the sum in the next column of the activecell.

Please Login or Register  to view this content.

[Norie]

Perhaps.

Please Login or Register  to view this content.

[ahilty]

Thank you both very much. Both solutions worked. I appreciate the help. Reputation Added.

[JOHN H. DAVIS]

You're welcome, glad to help out.