Hi All,
This is a two part question.
I have an existing report to which I need to insert an hyperlinked field at "A1" called Hlink.
I need to insert a column in before col B and name it "Hlink". Also, I need to have this column as hyperlinked and the text called "CONNECT"
I am not sure of how to use the OFFSET effectively.
The second part is:
for the address, I need to read values from the content of other fields in the report as in
This is part of the hyperlink code, I am trying to use
For i to LastRow
Str = “http://" & range(“URLAddress”).value &"sc=" testing & "ph=" & cell_that_contains_phoneNo & "st=" & cell_that_contains_starttimevalue & "et=" & cell_that_contains_endtimevalue
Range("A” & i").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address=Str, TextToDisplay:="CONNECT"
Next i
How do I read the sc, ph, st and et values?
sc: cell that contains service type (if the value is GUIDE, then sc = testing)
ph :cell_that_contains_phoneNo - 6th field
st:cell_that_contains_starttimevalue - 2nd field
et:cell_that_contains_endtimevalue - 3rd field.
I am attaching a sample report with bare minimum code.
Thanks,
Pragov