Code to export find and replace dialog box results

[seExcelHelper]

Hello, I am new to this forum and VBA. Wondering if someone has a VBA code to export find and replace dialog box results to a text file or another workbook. I have workbook with many external links, i used find "[" to locate all the external references. The results appeared in the Find and Replace Dialog Box. I would like to be able to write a code to export the "Book, Sheet, Cell, and Formula" information from the dialog box. Appreciate any help anyon can offer. Thank you.

Amy

[NickyC]

hi, assuming your search has tsaken you to a cell with an external link in it, and the link contains an external reference to a single cell or range in a separate workbook, this macro should create a single string that identifies the workbook, sheet and range references. You can use additional code to send this string to another workbook or an outlook message, or copy it to the clipboard.

Please Login or Register  to view this content.

[seExcelHelper]

Thank you NickyC for your response. Sorry, I know very little about VBA. I need to document all the external links in a workbook, the worksheet and cell location of the formula. Can this code also find the sheets, cells, and external link (formula) then send all the information to another workbook. I was manually documenting it and it is very time consuming. I was told to explore using VBA to get the information but unfortunately I am not a programmer. I truly appreciate your help.