Quote Originally Posted by Kyle123 View Post
.... Though don't forget the premature optimization!.....
.. your 100% right - I do have a problem / addiction, which is not always healthy. I may seek medical advice or just have to "Cold Turkey " me off my excel affliction soon - RL may force that…...)

…but while I am still for now “at it / inflicted…”
Some follow up Questions / observations..

Quote Originally Posted by Kyle123 View Post
…….Remember that whilst using formulas on arrays is possible, it usually much slower than simply looping through - on small arrays this is unlikely to matter a great deal, but it can have an impact on larger ones.!...... .
.. That surprises me a bit….. Often, in codes , as in earlier Posts in this Thread ( Post #7 ) I use the "Slicing of an Array idea", to get at 1 column.
.. I got that through Rick Rothstein and here
https://usefulgyaan.wordpress.com/20...ication-index/
I had thought I had read somewhere else as well, (maybe deep down in an Old Rick Rothstein Thread ) that speed advantages were reported over looping, at least in this case...(. Unfortunately in the amazing amount of Threads In this world, am unable to relocate it again just now..…)
So question 1) .. Any general comments on that, if you are familiar with this Method ?
………………………………….________________

…………………………………….
Quote Originally Posted by Kyle123 View Post
…… As an aside, the method you discuss is quite nicely written up here by DonkeyOte: http://www.excelforum.com/tips-and-t...2d-arrays.html.....
.. I note he goes straight from looking at Things in the spreadsheet with
=INDEX(_________)
To VBA codes with
Application.Index

Missing out the
Application.WorksheetFunction.Index(__________)

. I am unclear as to whether WorksheetFunction.Index is equivalent to =INDEX( in a spreadsheet. Or to make it even more confusing.. Are either of the following or both equivalent to
In VBA =Evaluate(“INDEX(____________”)

. I would like to experiment that one ,
.But it does get endless, and I do need to be careful about going / coming prematurely at these things...
. …So question 2): Have you ( or anyone else looking in ) got any input to “save” me on these last few points, that is to say
. 2 a ) are
=INDEX(_________)’…..Spreadsheet
=Evaluate(“INDEX(____________”)’….VBA Code
Application.WorksheetFunction.Index(__________)’…………VBA Code
… equivalent,
and again in case anyone else catching this Post can tell me if that is correct, or partly,
. 2 b )what is the difference in “working” / syntax between those and
Application.Index(__________)’…………VBA Code

Thanks again for the great Profi Input giving benefit of your experiences to help “save me” from my affliction!!
Alan