Built-in VBA search capabilities?

The (CTRL+F) search functionality in Excel will return a list of all cells (and their address) that contain the search string, if you select "Find All".

Is there a VBA function or library that will allow me the same functionality programmatically? I had envisioned sending a search string to the library or function and have an array be passed back to the initializing routine...

I am most interested in the cell addresses that contain the search string.
Any ideas? Thanks.

-Andrew

Hi Andrew,

I know of no way to do this in a single line of code.

But, you could use a Collection object to create a string of addresses. Something like this, maybe ...

Please Login or Register  to view this content.

Hi Andrew,

Here's another way of getting what you need:

Please Login or Register  to view this content.

Hope this helps,
theDude

Thanks theDude! The functionality of this coding worked very well... now, I am trying to find a way to do the same type of search, but in a different unopenned spreadsheet. Different approach all together or could I tweak your previous code example?

Hi Andrew,

My code won't run on an unopened file, but you can add this:

Please Login or Register  to view this content.

after the search term prompt:

Please Login or Register  to view this content.

Hope this helps,
theDude