ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Locate the Cells with the Formula and External Links (https://www.excelbanter.com/excel-discussion-misc-queries/177680-locate-cells-formula-external-links.html)

Jalal

Locate the Cells with the Formula and External Links
 
Would like to know how you can locate the Workbook/Sheets Cells that contain
Formula and External Links.

Gord Dibben

Locate the Cells with the Formula and External Links
 
You can look for [ or ] characters but easiest method is

Download and use Bill Manville's FindLink add-in.

http://www.oaltd.co.uk/MVP/Default.htm


Gord Dibben MS Excel MVP

On Sat, 23 Feb 2008 13:13:00 -0800, Jalal
wrote:

Would like to know how you can locate the Workbook/Sheets Cells that contain
Formula and External Links.




All times are GMT +1. The time now is 08:43 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com