Forum Discussion
Impossible to find an existing table
Deleted
you have another option as well if my previous techniques don't get you an answer.
1- Add the INQUIRE Tab to the Ribbon:
File >> Options >> ADD Ins >> Manage (lower Left corner) >> Select COM Addins (from the Drop List) >> Go >> Check the Box for INQUIRE >> OK >> It will be added to the Ribbon
2- Let's use it in Analyzing the workbook:
Click on the INQUIRE Tab of the Ribbon >> Click "Workbook Analysis" to the very Left (File should be saved first) >> in the Window that opens >> Under Items Check "Workbook" & Check " Ranges" >. Then Click on Export To Excel >> It will create a report that tells you if what you are looking for Exists or Not & Where it is.
I have a Tutorial on using the Inquire Tab:
Here is the Link:
https://www.youtube.com/watch?v=yOHJJcXtQq4
Hope that helps
Nabil Mourad