Posts by Benjamin Long7

Greetings,

I am not entirely certain if this is the right place for this, but since I couldn't locate a dedicated thread for Excel macros, I decided to start one here.🙂
I am looking for assistance with two specific macros in Excel:

1. A macro designed to scan an entire Workbook for a specific word. Essentially, I need an automated version of Ctrl + F that searches the whole file. If the term exists, it should pinpoint the location; if not, it should trigger a notification stating nothing was found.

2. A macro that opens a hyperlink contained within the currently selected cell. For instance, if I select a cell populated by data from another Excel sheet, I want a quick way to launch that URL immediately.

Does anyone have any insight on how to build these? I have spent hours scouring various online forums, yet I have come up empty-handed so far.

Thank you in advance.

Greetings, I am seeking assistance with developing an Excel Macro.

My goal is to take the content from a specific cell and input it directly into the Find What field.

Currently, my script is stuck; it simply repeats the exact value that was present when I recorded the Macro.

What I actually need is the flexibility to change the cell's value manually and then run the Macro to search for that updated information.

I hope my explanation is clear. 🙂

Thank you in advance. 🙂