View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
dpb dpb is offline
external usenet poster
 
Posts: 109
Default How to locate cells with links to other cells/worksheets

On 4/21/2018 11:27 AM, dpb wrote:
On 4/21/2018 8:30 AM, pedro wrote:
...

Oh for the times past when a MS MVP would pop in with a solution.

Anybody?


<https://support.office.com/en-us/article/find-links-external-references-in-a-workbook-fcbf4576-3aab-4029-ba25-54313a532ff1


I've not tried, but I see no reason one couldn't write a user function
to return formulae as string and parse them to automate the process...

--