Hi kyle, if you happen to look in here again..(Or anyone else dropping by…)
… I’m afraid I am still trying to “set” or “get” a few things clear in my mind…
. 1) …..”getter” or “setter)
. …

Originally Posted by
Kyle123
.Value / .Value2 is indeed a function/property and my answer was correct, however you can use that syntax on any array as a getter, just not a setter
. Could you elaborate a little on that? Maybe you are answering one of my previous questions there, but I am not too familiar with what the term setter and getter is saying here.
. 2) .Value and .Value2 property or method or function.
. A trivial question maybe but it can throw a beginner off-course..
. I have seen experienced users refer to these two things as either property or method or function. And the Object window F2 is not a great help : Often the same name is given to properties and methods/Functions, which means you often need to know the answer before knowing where to look for the answer!!!!
. I note that .Value is not to be seen in the Watch Window for a big Range Object. .Value2 is. So maybe .Value is a Method which is used to get something similar to .Value2 which is then maybe a Property?. Charles Williams is not sure and did some experiments like I did to try and find out. He found that Value2 is always better and quicker especially when used with the variant Array idea similar again to what I have been finding. So maybe it all ties up.
( I expect you may say I should look in the Object Library. But I have been caught out in the past on this one as Methods and Properties sometimes have the same names and you then need to know the answer first to know where to look for the answer!! )
.3) A quick yes to this would do. Have I been continually fooling myself into thinking I have / can “capture” a big Range with all it’s info in it with…
But in fact I have nothing but a whole lot of “Directions” or “paths” or “references” which always take me to that Range and hence result in an interaction with the worksheet.?
(…I have been told this I think a few times, for example..

Originally Posted by
romperstomper
Whenever you interacted with a range object in the array, you would be interacting with the worksheet, so there would be no benefit to having an array of range objects rather than one…
… .
… but some of my weird experiments have turned up some anomalies… … using an intermediate step with a code which uses an array of range objects but stores them as full Objects as Keys along with an variant itermediateArray of range Objects almost works as fast as when ignoring this intermediate step which otherwise greatly increases times.. I have no idea what use this could be.. … yet!!.….?.)
. No Rush on any answers here, rather an in depth answer should anyone have the time.
. Thanks, sorry for continual questions here, I hope to clear this one up in my head soon!
Alan
Bookmarks