How to find cells without hyperlink in Excel?

Question

Macros

Good afternoon, I need help. There is a document with 270k lines with a hyperlink to the document in each. The links were created by the script, and some cells are missing links. How can I search to find the next cell in which there is no hyperlink? PgDn sooo long

Answer 1

Click on the cell with hyperlinks
Sorting
All empty ones will be either on top or bottom
Do what you need with empty ones.