Just testing colur formats, copying in iun different browsers etc.
. ...........One last useful observation here: One can of course do justVBA . Following on from that last code line, a classic example given is usingVBA to get the =Evaluate ( “ = A1 “ ) . The corresponding mainly orexclusively VBA Code Evaluate would be
Excel Spreadsheet =A1 = Evaluate("=" &ws.Range("A1").Address& "")'Explicit Version
Excel Spreadsheet =A1 = Evaluate("" &ws.Range("A1").Address & "")'Implicit Default
A characteristic of the VBA Evaluate Method, ( or rather The building of its String Argument ),which can be helpful in particular when trying to understand the tricky Themeof the different type of quotes in a long complicated string Argument, is thatthe pair of effectively empty VBA Evaluate quote pairsused in conjunction with an ampersand to linkThe Spreadsheet“world” to theVBA CodeWorld can have any amount of spaces betweenthem with no effect on the code line.
. So that last line May be rewritten
Let ws.Range("B2").Value = Evaluate("big empty light grey space" & ws.Range("A1").Address& "big empty white space") '
. As long as there is something in the total string that can be evaluated thiswill not error. The explanation would be that within the VBA Evaluate “ “pair nothing is being evaluated. It is a deadspace.
There will be situations where thiscan help later to identify which quotes are which, or to which “world” theybelong**................ so further
...................................
add spaces 1 to 2 to get rid of lost spaaces in original text
............One last useful observation here: One can of course do just VBA . Following on from that last code line, a classic example given is using VBA to get the =Evaluate ( “ = A1 “) . The corresponding mainly or exclusively VBA Code Evaluate would be
Excel Spreadsheet =A1 = Evaluate("=" &ws.Range("A1").Address& "")'Explicit Version
Excel Spreadsheet =A1 = Evaluate("" &ws.Range("A1").Address & "")'Implicit Default
A characteristic of the VBA Evaluate Method, ( or rather The building of its String Argument ), which can be helpful in particular when trying to understand the tricky Theme of the different type of quotes in a long complicated string Argument, is that the pair of effectively empty VBA Evaluate quote pairsused in conjunction with an ampersand to link The Spreadsheet“world” to theVBA CodeWorld can have any amount of spaces between them with no effect on the code line.
. So that last line May be rewritten
Let ws.Range("B2").Value = Evaluate("big empty space" & ws.Range("A1").Address& "big empty space") '
. As long as there is something in the total string that can be evaluated this will not error. The explanation would be that within the VBA Evaluate “ “pair nothing is being evaluated. It is a dead space.
There will be situations where this can help later to identify which quotes are which, or to which “world” they belong**................ so further
...................................
Let ws.Range("B2").Value = Evaluate("big wmpty grey space" & ws.Range("A1").Address& "big empty white space") '
.................................................. ..........................
Very light GREY Text light GREY light GREY light GREY
WHITE Text WHITE WHITE WHITE WHITE WHITE
Grey White text GreyWhite GreyWhite GreyWhite
Code:
Range("I1").Value = Evaluate(" " & Range("A1").Address & " ") '
Code:
Range("I1").Value = Evaluate(" " & Range("A1").Address & " ") ' Demo for spaces..
.... ) )
Bookmarks