Macro URL syntax error

Hello,

With this code:

Please Login or Register  to view this content.

I want to change LUV into this....

& Range("a1").Value

So I can get any stock but I cant get the syntax to work. Any ideas please?


Also I've been using this code:

Please Login or Register  to view this content.

And it has worked for me, but I wanted to use data from the stocks "key statistics" page but again cant seem to be able to add changes (such as & Range("a1").Value) into the middle of the url

I hope this makes sense

Thanks for reading

Like so.... I changed the Destination to B1:

Please Login or Register  to view this content.

I fixed your post #1 adding the missing CODE tags, then you edited post #1 and removed them again. Please take a moment to understand the tweak I've made, use of CODE and /CODE tags one of our forum rules, we need you to be sure and abide them, as do we all. Thanks so much.