Hello once more,
I have a serie of numbers in A1, B1, C1 to x1.
I want to total the numbers from A1 to x1, the answer must stand in the cell next to x1!!!
[A1].End(xlToRight)(1, 2).Value = Application.Sum(Range([A1], [A!].End(xlToRight)))
This does the trick, BUT when I change a number the total doesn’t change.
I must play the macro again and then it will.
But I only want the macro to play just once.
Therefore it must be a formula that stands in x1.
How do I do that?
The solution must be in VB!
I have a serie of numbers in A1, B1, C1 to x1.
I want to total the numbers from A1 to x1, the answer must stand in the cell next to x1!!!
[A1].End(xlToRight)(1, 2).Value = Application.Sum(Range([A1], [A!].End(xlToRight)))
This does the trick, BUT when I change a number the total doesn’t change.
I must play the macro again and then it will.
But I only want the macro to play just once.
Therefore it must be a formula that stands in x1.
How do I do that?
The solution must be in VB!