single quote

  1. M

    VBA Not Interpreting Single Quotes Correctly

    Hello, As part of a larger macro, I'm trying to input a formula into a range of cells. This formula does an indirect lookup of a worksheet name as a tab name, and therefore requires single quotes. However, VBA keeps trying to interpret the first single quote as a comment, and therefore...
    • Mayanwolfe
    • Thread
    • formula & macro quotation marks single quote vba vba formatting
    • Replies: 3
    • Forum: Excel Questions
  2. A

    single quote error

    I am trying to update a SQL table with the string from excel using vba. strBrokerCategory (sixth line) has a value of "Cat 29 OTC / 2930 Women's Health". The single quote is causing issues for me. How can I fix this ? I tried a Replace(strBrokerCategory, "'", "''") but it does not help. Any...
  3. S

    Single quote coming automatically

    Hi I am trying to concatenate a number value with string and setting the result to a cell value. It was adding a single quote at the start automatically and only visible from formula bar. I dont want to have this single quote and i really dont understand from where it is getting appended...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top