Is there a faster, better way?![]()
Please Login or Register to view this content.
Is there a faster, better way?![]()
Please Login or Register to view this content.
Thank You,
EnigmaMatter
Perhaps
![]()
Please Login or Register to view this content.
- Battle without fear gives no glory - Just try
Curiosity, why does this work so much better than my script?
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.
try
![]()
Please Login or Register to view this content.
Mr. Jindon What if I want the results to be in Q2:Q & LastRow?
PCI,
It bugs on:
in line:![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
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.
Last edited by PCI; 01-21-2015 at 04:58 PM.
It looks identical except it is in a table...but yours works in a table too...
PCI,
Your substitute line worked! Thanks!
Why did it work?
I have the "feeling" there is not only numbers in your data, that's why it is always better to have a sample ...!
Mr. Jindon What if I want the results to be in Q2:Q & LastRow?
Thanks advanced
![]()
Please Login or Register to view this content.
Thanks a lot Mr. Jindon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks