Stuck. I need some VBA code to insert double-quotes around strings in each cell in an excel range -


I am familiar with VB.NET, but VBA in Excel has stumped me. With my best effort, I get a "type mismatch" error:

  sub-addQuotes () for each x in the range ("list"). Room x.Text = "*" * "& amp;; X. Tech & amp; & amp; "*" Next closing sub  
= "post-text" itemprop = "text">

Try chr (34) for double-quote character

For example chr (34) & amp; X.Text & amp; Chr (34)


Comments