VBA to find text in specific format in a workbook

I am looking for code to find text in a specific format with in a workbook. The code would be

Please Login or Register  to view this content.

if I wanted to search every cell, but I am hoping there is a quicker way using worksheet.find(). ex:

Please Login or Register  to view this content.

Thanks for any help,
H

There are several experts working on this already, so I won't join them as yet.

I must say however you haven't stated what you want done when and if that data is found.

May I suggest that an index sheet be created and a list created in columns A, B and C

Column A to list the sheets in which the text appears
Column B to list the cell in which the text appears
Column C to list the exact contents of that cell.

The cells containing the text in that format are names of data entries over several years. I am looking for a quick way to cycle through several workbooks and collect the data associated with that name.
The problem comes because the format of the workbooks is not consistent and the data associated with the name is located on one sheet in each workbook. The sheet name and number are not consistent
from workbook to workbook. To make things more complicated there are other tables on the same worksheet that contain similar data, but not reduced to the name. Long story short, I will take the cell
contents and the contents of the next 11 cells in that row and paste them in a table in the workbook running the macro. I believe I know how to write the rest of the code, but am struggling with finding
the data in the workbook.

Thank you for the look ahead and suggestion,
H

This will find cells formatted as currency.

Please Login or Register  to view this content.

Perhaps you can modify for your use. Hope that helps.

I have been unable to modify the code so far. It appears that the numberformat will only accept numbers and there is no text format I can find. Does anyone have an idea?

Thanks for code,
H

I greatly appreciate the help. If I use an If statement tied with Like the format is # is a number and letters put in a bracket are possible letters. For example:

Please Login or Register  to view this content.

would only return true if the cells contents had four numbers then a dash followed by a number and a letter. The star means that any value can exist in the rest of the string [Letters and numbers]. The reason is the names change for every instance and there are multiple areas inside each instance therefore only the fist part of the name convention is the same every time. That is 4 numbers followed by a dash then another number and a letter.

Thank you again and I will be by my email if you have any questions,
H

Thanks for all the hard work. The code looks good, but I don't have access to the excel workbooks until tomorrow. I will let you know how it goes.

Thanks again,
H