It’s a best practice to use parentheses whenever you can in Excel formulas, even if the use of parentheses seem to be superfluous. The liberal use of parentheses can not only help you avoid calculation errors but also help you better understand what the formula is doing. You can even nest ... 4. Add "CHAR(34)" anywhere you need a double quotation mark to appear. This mark counts as any other text or cell reference, so you need to segregate the marks with commas.

Mar 27, 2008 · Quotes/Quotation Marks In Formula Macro Code Mar 27, 2008. how do i put a formula using: activecell.formula"=CODE("A")" with " in it it just dosent work and is there a way to use the returned value of these formulee in macros with out actually putting them into a cell. View 4 Replies Similar Messages: Inserting Quotation Marks Into VBA Code Our formula will be similar to the previous example, but we'll need to change the first three arguments. Let's start by changing the first argument to a cell reference (make sure to remove the quotation marks): =VLOOKUP(E2, A2:B16, 2, FALSE) To find the category, we'll need to change the second and third arguments.