What do you want to save?
Add Code snippet
New code examples
-
VBA 2022-03-15 05:15:29
vba should i use .value .value2
'Go with: Range.Value2 '<------Best way 'It is almost always the best choice to read from or 'write to an Excel cell or a range... from VBA. 'Each of the following can be used to read from a range: v = [a1] v = [a1].Value v = [a1].Value2 v = [a1].Tex... Add solution -
VBA 2021-11-17 22:29:14
How do I put double quotes in a string in xl vba
'Including double-quote characters in VBA string literals can be confusing. 'First, realize that VBA (unlike many languages) does not recognize the 'apostrophe as a quotation mark. In JavaScript, for example you can simply 'do this: ' var s = 'The "... Add solution -
VBA 2021-09-15 05:39:02
excel vba range.text
'Go with: Range.Value2 '<------Best way 'It is almost always the best choice to read from or 'write to an Excel cell or a range... from VBA. 'Each of the following can be used to read from a range: v = [a1] v = [a1].Value v = [a1].Value2 v = [a1].Tex... Add solution -
VBA 2021-09-06 00:55:01
excelvba quotes in string
'Including double-quote characters in VBA string literals can be confusing. 'First, realize that VBA (unlike many languages) does not recognize the 'apostrophe as a quotation mark. In JavaScript, for example you can simply 'do this: ' var s = 'The "... Add solution
Best helpers
Holyeyeolo
+5
Auntkym
+5
Mostafa 36a2
+5
Rodrigorgs
+5
Arnav Bose
+5
Waldrumpus
+5
TheShade
+5
Piquet
+5
Babak
+5
Ohhh
+5
Jeff Sours
+5
Jim Mourgos
+5
J. Marks
+5