Faster Way to Substract 2 Columns?

[EnigmaMatter]

Please Login or Register  to view this content.

Is there a faster, better way?

[PCI]

Perhaps

Please Login or Register  to view this content.

[EnigmaMatter]

Curiosity, why does this work so much better than my script?

[PCI]

Because access to the spreadsheet is limited to the minimum:
All data is read and put in memory in one shot: Wktb1 = WkRg, WkTb2 = WkRg
Treatment is done in memory
Complete result is written in one shot in the cells

Please Login or Register  to view this content.

[jindon]

try

Please Login or Register  to view this content.

[YasserKhalil]

Mr. Jindon What if I want the results to be in Q2:Q & LastRow?

[EnigmaMatter]

PCI,

It bugs on:

Please Login or Register  to view this content.

in line:

Please Login or Register  to view this content.

[PCI]

Can you send a short sample of your data, with mine it was OK
Perhaps try depending of your data

Please Login or Register  to view this content.

[EnigmaMatter]

It looks identical except it is in a table...but yours works in a table too...

[EnigmaMatter]

PCI,

Your substitute line worked! Thanks!

Why did it work?

[PCI]

I have the "feeling" there is not only numbers in your data, that's why it is always better to have a sample ...!

[YasserKhalil]

Mr. Jindon What if I want the results to be in Q2:Q & LastRow?
Thanks advanced

[jindon]

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot Mr. Jindon