Automating JPG Image Downloads in Excel with VBA

💡 Introduction
Ever found yourself manually copying hyperlinks from an Excel sheet? 😩 If you're dealing with a large dataset, this task can be frustrating and time-consuming. Thankfully, VBA (Visual Basic for Applications) can automate this for you in just a few seconds! 🎯

📝 VBA Code to Extract Hyperlinks

Sub ExtractHL()

    Dim HL As Hyperlink

    For Each HL In ActiveSheet.Hyperlinks

        HL.Range.Offset(0, 1).Value = HL.Address

    Next

End Sub

🔍 How This Code Works

✅ Step 1: The macro scans all hyperlinks in the ActiveSheet. 🔎
✅ Step 2: For each hyperlink, it takes the URL (Address) 📎.
✅ Step 3: It places the extracted URL in the next column (column B if hyperlinks are in column A). 📤

🛠️ How to Use This Macro in Excel

1️⃣ Open Excel and press Alt + F11 to open the VBA Editor 🛠️
2️⃣ Go to Insert > Module 📂
3️⃣ Copy and paste the VBA code into the module ✍️
4️⃣ Close the editor and go back to Excel
5️⃣ Press Alt + F8, select ExtractHL, and click Run ▶️

🎯 Expected Output

If you have hyperlinks in column A, this macro will extract them into column B:

A (Hyperlinked Text)	B (Extracted URL)
Click here	https://example.com
My Website	https://mywebsite.com

📢 Now you have all your links neatly extracted! 🎉

🔔 Final Thoughts

With just a few lines of VBA, you can extract hyperlinks in Excel effortlessly. 🚀 No more manual copying—let VBA do the hard work for you! 😎

💬 Need more Excel automation tricks? Let me know in the comments! 📝