wildcard use in range .find

[par60056]

I am running a macro against 20 workbooks. It appears that there is no consistency in how thay are created.

I am trying to copy a few cells from one of the sheets. I am using the .find method to locate the beginning of the data to copy.

I thought I was going to be able to do:
cells.find("BLAH - Content")

But unfortunately some people put "BLAH - Content" and some put "BLAH - FY16 - Content".

I can't search for starting with BLAH. It is too common in the file.

Is there a wild card with .find?

 

[par60056]

Never mind. Threw in some * and it worked.

 

[MrKowz]

For additional wildcard info and uses - check out Excel Wildcard Characters - Why Aren't You Using These?