Search for a string or integer, and display the coordinates of all cells that contain the string or integer

[tomcharter365]

Summary

There should be a function to search a xlsx document for a specific string or integer, and then print out the coordinates (eg: A1, B5) of any cell that match the search criteria.

Search could be similar to how AutoFilter can filter for expressions.

Example

Example file attached
example.xlsx

Reason Feature will be useful

This search feature would be very useful in looking for a string such as apple and then passing the cell coordinates (B6) into a variable so that another function in the script can process or validate data programmatically.

As of right now, there seems to be no way to do this unless the cell coordinates are known.