
Originally Posted by
YasserKhalil
Thank you very very much Mr. Alan
...
.
Hi YasserKhalil,
. Thanks for the feedback
Alan Elston
. BTW. ( By the way ) – I am looking also for my project in speeding things up a bit, possibly using Arrays. Amongst other things, I am considering a simple routine in place of the .Transpose Function. So I have as a by-product of this work another code version that you may wish to consider.. The basic form of the code is identical to that for my code from post #14. It is therefore in its more usually given, simplified form, and without most of the 'green comments
. However the .Transpose part is replaced with a simple routine ( Placed in a Function for clarity of code layout. )
.
. Here the codes. ( You copy both codes to the same Module. But you only run the first Sub. This is because the Fuction is “called” when needed ( twice in this case from the first Sub ) ) . For the Fuction I have include my usual explaining 'green comments.
Codes
.
………………
. BTW. If you are testing all the above codes you have been given, along with yours and are comparing the speeds in large circuits it would be a great contribution to this Thread to Post your results. Post also a copy of your code attempt.. This would make this Thread a very useful one for future reference.
Bookmarks