Display single quotation mark as text using VBA

[csilabgirl]

Using excel 2010

I have the following line of code. Range("D13") = "(6) 1 1/4" Screws"

I want range D13 to say the following:

(6) 1 1/4" Screws

I want the single quotation mark after 1 1/4 to be displayed since it's denoting inches. But I keep getting a debug. What do I need to add to this to get that to display? Thank you.

 

[iliace]

First of all, that is a double quotation mark, not a single quotation mark.

The way to do it in VBA (one of them), is to double up on the double quotation marks:

Range("D13") = "(6) 1 1/4"" Screws"

The first " is what's called an 'escape character', that lets VBA know it is an exception to the rule. Because VBA normally interprets " as a beginning or end of a string of text, you have to use the escape character to let it know that you literally want a double quote character.

Does that help / solve your issue?

 

[csilabgirl]

You're right, I meant to say a single double quotation mark. That fixed the issue, thanks so much.