Hyperlinks help using a cell reference

[288enzo]

My code that is giving me trouble is -

Range("AA5").Hyperlinks.Add Anchor:=Range("AA5"), Address:="https://webaddress.com/?query=" & G5, TextToDisplay:=G5

I'm getting Run-time error 5: Invalid procedure call or argument.

Essentially, what I'm trying to accomplish is to change all cells in column G to a hyperlink. If I could get the above to work, I was going to simply copy and paste the formula down, copy cells in AA and paste them back into G.

 

[288enzo]

Well, my suggestion was there 4 minutes before you figured it out.

Thank you for that, but I am still searching the web for help and trying different ideas, and not simply sitting and waiting for someone to respond to my post.

I do appreciate the help, and your idea of using brackets instead of "Range" will save me a few key strokes later on. Always learning new tips and tricks on this site.