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