Sum values within a single cell

[macropod]

Originally Posted by shabbaranks

If you create an xlsx and you apply the VB as soon as you exit and go back into it you haven't got the code anymore (because its now a xlsx) and so the calculations don't work - unless Im missing something?

Originally Posted by BobBridges

But Paul, I don't see why you told him it would work with .xlsx files.

If you two would take the time to read my replies, you just might save yourselves some confusion and me some time!

Originally Posted by macropod

The solution I posted works with xls and xlsm files, just not xlsx files...

Now, compare what I wrote against your posts...

[BobBridges]

Oops. I read it, I just read it too fast and wrong; I thought you wrote "...works with xls and xlsm files, not just xlsx files". My bad.

[Pecoflyer]

Originally Posted by BobBridges

Oops. I read it, I just read it too fast and wrong; I thought you wrote "...works with xls and xlsm files, not just xlsx files". My bad.

I also read it wrong....

[macropod]

Originally Posted by BobBridges

Oops. I read it, I just read it too fast and wrong; I thought you wrote "...works with xls and xlsm files, not just xlsx files". My bad.

That is what I wrote...

[BobBridges]

Not unless you changed it later. I thought you wrote "...not just .xlsx files"; what appears there now is "...just not .xlsx files". I'm glad I'm not the only one whose eyes found it easy to reverse the two words.