Strings that have quotes in them
 

I have a string of text that i need to put in vba, however the strin
itself has quotes in it, so how do i properly write thi
line...everything that's blue is a break in the string where i need t
put vba code :

=HYPERLINK("[I:\General Documents\ & Format(Date, "mmmm")
\Returns.xls".xls] & Sheets(ActiveSheet.Index + 1) & !A1",
txtName.value & )



Thanks! :

--
Message posted from http://www.ExcelForum.com

Strings that have quotes in them
 

both of these give the same result

sstring = """"
sstring = "ggggggg" & """" & "gghbnfg"


sstring = Chr(34)
sstring = "ggggggg" & Chr(34) & "gghbnfg

--
Message posted from http://www.ExcelForum.com