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

" 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