Hello,

This is a snip from the code I am running on the sheet:

If IsEmpty(Target) Then Target = "15" E551 - $300"

I want it to return '15" E551 - $300'

The problem I am having is the ability to use the inches symbol ("). I
get an error when I use this code because visual basic thinks that the
" is the end of the value.

Anyone have any idea how to get around this?

Thanks

Sean

If IsEmpty(Target) Then Target = "15" & chr(34) & " E551 - $300"

--
HTH,
Gary Brown
(E-Mail Removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.


"(E-Mail Removed)" wrote:

> Hello,
>
> This is a snip from the code I am running on the sheet:
>
> If IsEmpty(Target) Then Target = "15" E551 - $300"
>
> I want it to return '15" E551 - $300'
>
> The problem I am having is the ability to use the inches symbol ("). I
> get an error when I use this code because visual basic thinks that the
> " is the end of the value.
>
> Anyone have any idea how to get around this?
>
> Thanks
>
> Sean
>
>

Maybe Target.Value = "15"" E551 - $300"

Two doublequotes after the 15.

--
Jim
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
| Hello,
|
| This is a snip from the code I am running on the sheet:
|
| If IsEmpty(Target) Then Target = "15" E551 - $300"
|
| I want it to return '15" E551 - $300'
|
| The problem I am having is the ability to use the inches symbol ("). I
| get an error when I use this code because visual basic thinks that the
| " is the end of the value.
|
| Anyone have any idea how to get around this?
|
| Thanks
|
| Sean
|

Hi Sean,

In my limited vba experience I have found that quotations have to be
surrounded by double quotations. Try this: "15" & """" & " E551 - $300".

"(E-Mail Removed)" wrote:

> Hello,
>
> This is a snip from the code I am running on the sheet:
>
> If IsEmpty(Target) Then Target = "15" E551 - $300"
>
> I want it to return '15" E551 - $300'
>
> The problem I am having is the ability to use the inches symbol ("). I
> get an error when I use this code because visual basic thinks that the
> " is the end of the value.
>
> Anyone have any idea how to get around this?
>
> Thanks
>
> Sean
>
>

In my limited vba experience, one has to put in double quotations around
quotations. Try this: "15" & """" & " E551 - $300"

"(E-Mail Removed)" wrote:

> Hello,
>
> This is a snip from the code I am running on the sheet:
>
> If IsEmpty(Target) Then Target = "15" E551 - $300"
>
> I want it to return '15" E551 - $300'
>
> The problem I am having is the ability to use the inches symbol ("). I
> get an error when I use this code because visual basic thinks that the
> " is the end of the value.
>
> Anyone have any idea how to get around this?
>
> Thanks
>
> Sean
>
>

Or:

If IsEmpty(Target) Then Target = "15" & Chr(34) & " E551 - $300"

"(E-Mail Removed)" wrote:

> Hello,
>
> This is a snip from the code I am running on the sheet:
>
> If IsEmpty(Target) Then Target = "15" E551 - $300"
>
> I want it to return '15" E551 - $300'
>
> The problem I am having is the ability to use the inches symbol ("). I
> get an error when I use this code because visual basic thinks that the
> " is the end of the value.
>
> Anyone have any idea how to get around this?
>
> Thanks
>
> Sean
>
>