Appendix-Thread-Evaluate-Range-(-Codes-for-other-Threads-HTML-Tables-etc-)

[DocAElstein]

Some *more notes, (* second time around) in support of this forum post
https://eileenslounge.com/viewtopic....28c881#p309137
Excel - alignment of numeric values in cells? https://eileenslounge.com/viewtopic....310023#p310023 https://eileenslounge.com/viewtopic....310024#p310024

---

I did a solution who’s basic form started like this , pseudo coding

  Range2 =  Evaluate("=IF(ISNUMBER(A1:F7),1*A1:F7, A1:F7)")

The logic was that
_ if ISNUMBER( ) recognised a number held as text in any cells, then those cells would be multiplied by 1 to change them to normal numbers
_ the final modified range would then be returned/ put in the Range2
It seemed to work. Well it does. But my logic is up the spout, totally.
_ For one thing, ISNUMBER( ) does not recognise a number held as text as a number https://www.excelfox.com/forum/showt...ll=1#post22079
_ On the right hand side, RHS, of a typical code line like this ,
Range2.Value = Range1
, if Range1 is a multi cell range, then nothing at all is returned!!! #21995 #12 https://www.excelfox.com/forum/showt...age2#Post21995

So what the fuck is going on…..
Take a look at the coding in the next posts, https://www.excelfox.com/forum/showt...age2#Post21995
https://www.excelfox.com/forum/showt...ll=1#post23186
We are looking at various variations of code lines with a similar RHS Evaluate(" ") to that in my original initial solution. We apply the result to both
_ a test range, which corresponds to the LHS idea of Range2.Value = Range1
_ we also apply it to a Variant variable
_ we also apply it to a Variant variable
We use the test range A6:A7 which has a number held as text and also a normal number
https://i.postimg.cc/fLXddyGQ/A6-A7.jpg
A6 A7.JPG


In the coding I have put the results of the Watch Window in the 'comments

Now let’s analyse some of those results
https://www.excelfox.com/forum/showt...ll=1#post23189
https://www.excelfox.com/forum/showt...ge59#post23189