View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
abxy[_53_] abxy[_53_] is offline
external usenet poster
 
Posts: 1
Default 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