Trying to put a variable in a URL to be Hyperlinked. Help please

[RooparDE11]

So I'm trying to put a variable into a URL that is going to be hyperlinked. if i do a " & Folder1 & " then it simply leaves it out and merges the URL without inputting what is within the variable Folder1. The same goes for Plant and Manifest.
What's in red is my problem. Help please.

Here's what I've got:

Dim Plant As String
Dim Folder1 As String
Dim Manifest As String

Manifest = ThisWorkbook.ActiveSheet.Cells(Rb, C).Value

ThisWorkbook.ActiveSheet.Hyperlinks.Add Anchor:=Cells(Rb, Cl), Address:="https://controls.company.com/station/decom/" & Plant & "/Environmental/" & Folder1 & "/Manifest.pdf", TextToDisplay:=Manifest

 

[RooparDE11]

So after much debugging I found that I was simply not referencing the correct sheet.

So if you need this and it helps you then here's the correct macro.


Function hyperL(R, C, Rl, Ro, Rb, Cl, Manifest)

Dim Plant As String
Dim Folder1 As String
Dim Manifest As String

Manifest = ThisWorkbook.ActiveSheet.Cells(Rb, C).Value
Call Identifyer(Plant, Folder1)
ThisWorkbook.ActiveSheet.Hyperlinks.Add Anchor:=Cells(Rb, Cl),_ Address:="https://controls.company.com/station/decom/" & Plant & "/Environmental/" & Folder1 & "/" & Manifest & ".pdf", TextToDisplay:=Manifest