. 3 ) Some conclusions “Quotes in VBA” ...
. Taking the lastcode lines, - I may happily remove the two extra" & "which as discussedare just linking text elements.. to give simplified finally
. 100 .-- VBA =Evaluate("=A1" &"&"";""""""")
.. my final solution isI have ( I think ) some theoretical argument given to a convention to produce aquote in a VBA Evaluate string, as well as seeing a similar logic for theSpreadsheet equivalent, that is to say for theSpreadsheet an extra "" to what one would usually write : Similarargument again : once in the String you write in the cell for example
=";" ( Result in cell is ; )
Or for an extra “ youwrite
=""";" ( Result in cell is "; )
SummaryAdding a Quote After a text bit that should beoutputted as Final result:
. 3 a) VBA Evaluate ( Wot you write in the String for the Evaluate ):
.
. ""TextBit""""""( The last" is removed from my above example as that is just thelast end “ at the end “) ). In words: the Text Bit and 6 quotes all green . ( Note if already within a long string with the "start text" and "stop text" pair &""____""& then 4 qoutes are needed """" )
Or
for no text 8 quotes all green.
. For nothing but a quote in a cell using evaluate,8 quotes all green in the middle, two blue quotes, one on each end, 10 intotal!!. .. ("""""""""") _____ ("" & """""""""" & "")
.
. 3 b ) Spreadsheet World ( Wot you write jn the cell ):
.
. TextBit""
.
......................
. A lot of people know those two summaries, But I do not think they have a theory as to why...( I have at least one I think has some logic in ... maybe.. ? )
. Thanks for watching
. Alan
.....
Reply With Quote
Bookmarks