I found that data like
=HYPERLINK("https://tfl.gov.uk/bus/stop/490004733D/canada-water-bus-
station?lineId=1", "Canada Water Bus Station stop ?")
were written as strings, rather than formulae.

I NOW have code which seems to work
Static cell(1 To 256) As variant

Why the difference?

When coding for Cell.Formula the entire formula needs to be a string in
VBA. This means the single quotes within the formula require being
wrapped in quotes so they get interpreted correctly. So...

"Canada Water Bus Station stop ?"

...needs to be coded...

"""Canada Water Bus Station stop ?"""

The entire formula needs to be coded as follows...

Cell.Formula = "=HYPERLINK("""https...lineId=1""","""Canada...?"" ")"

I suspect using a variant type causes VBA to sort this out itself,
possibly?

As for emailing.., best to upload a file to a public drop box and
include your email in the file.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus