.. 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..
.. 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 ?
………………………………….________________
…………………………………….
.. 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
Bookmarks