wildcard use in range .find

par60056

Well-known Member
Joined
Jul 26, 2012
Messages
1,579
Office Version
2011, 2010
Platform
Windows, MacOS
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?
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

par60056

Well-known Member
Joined
Jul 26, 2012
Messages
1,579
Office Version
2011, 2010
Platform
Windows, MacOS
Never mind. Threw in some * and it worked.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,413
Messages
5,414,275
Members
403,522
Latest member
Abel_excel

This Week's Hot Topics

Top