URL decoding entire worksheet

Support
#1

Is it possible to convert all URL encoded text in an entire worksheet without creating a formula for each cell?

#2

Yes, VBA should do it for you. Have you used it before?

#3

Yes. Do you have a function you can send to me?

#4

Hi @quickeningray.

I got an Excel with a list of of URL's and i need them to be Hyperlink all of them. For that, i use this code:

Range("A1").Select
Do Until ActiveCell.Value = ""
    ActiveCell.Hyperlinks.Add Selection, ActiveCell.Value, , , ActiveCell.Value
    ActiveCell.Offset(1, 0).Select
Loop

This works for me because my list of URL start in cell A1. Hope you can adapt this code to your needs.

Hope it helps.