HELP: Inserting an HTML code as text into VBA

[Teeks2k]

Hello,

I am writing a macro to build a template that will be uploaded into another program and I am having some problems with this one bit:

For i = 1 To LR
With FN_Upload
        Sheets(3).Range("A" & i + 1).Copy Destination:=FN_Upload.Range("D" & i + 1)
        .Range("A" & i  + 1).Value = "ADD"
        .Range("B" & i + 1).Value = 10488
        .Range("C" & i + 1).Value = 2
        .Range("E" & i + 1).Value = 3
        .Range("F" & i + 1).Value = 3
        .Range("G" & i + 1).Value = "Click <a href="https://yaddayaddayadda.com"> here </a> for Listing." 
End With
Next

The rest of the code works fine except for the last column where I try to add the HTML hyperlink code. The intent is for column G to show that string as text for the other program to read.

Thanks!

 

[Norie]

What exactly is the problem?

Are you using single or double quotes for the href attribute in the HTML code?

 

[Teeks2k]

I get an "Expected: end of statement" error when I try to compile, even with double quotes
"Click <a href=" https://yaddayaddayadda.com/ ">here< /a> for Listing." is the text that I am trying to populate the cell with

 

[Norie]

If this is for HTML try using single quotes.