Find partial date string within date column

I have been unable to use the Find Method in order to find a substring of dates within a date column
For example, I would like to find the string "08/1980" in a column which contains dates displayed in DD/MM/YYYY format in order to loop through all rows with a date in August 1980

It works manually, and if I record a macro doing that search, executing the macro produces an error. The macro contains only one line :
Selection.Find(What:="08/1980", ...).Activate
And since the Find method does not work, there is no range returned and the Activate method runs into an error.

Please note that the thing works for finding whole dates, using Find(What:=Cdate("1/8/80")...) This works OK. The problem is when searching for substrings

Any help would be greatly appreciated !

Jean-Marie

Thank you Bernie, this is a nice solution indeed, for most cases.
Except for me for two reasons :
1) my code is in a UserForm which is displayed on top of the sheet, which enables me to edit the content of a row and to search for particular values in any column. I would prefer a solution where I would not have to filter the underlying sheet.
2) The sheet contains references to about 5000 speeches that were given over a period of about 40 years, and I receive comments on these speeches, which I must process. One comment will address the speech of such and such date, and sometimes there is an error on the date mentioned, the day or month or year can be wrong, and I must find the right speech concerned, looking at the speech title and summary compared to the comment.
So for the problem to be expressed completely, I might be looking for the string "01/08" looking for all speeches given on a 1st of August, then spotting the right speech when looking at the title and summary !

The manual search for such substrings works, but apparently not by macro !

Thank you for all your answers
There is not much need to provide a worksheet to demonstrate the problem. It is very easy to reproduce :
Type in a few dates on a given column of a worksheet,
Then select that column, start recording a macro, search for a sub-string appearing in one of the dates : you will see that Excel finds it.
Turn off macro recording
Now select again the column and run the macro : it runs into an error.
As leelnich mentioned, the problem stems from not finding a cell that matches the search. But why does it not find it by macro when if does find it by manual search ?

Thank you leelnich, but why the Find fails even if there is an instance of the searched string. That is the problem !

Are you ABSOLUTELY certain you're searching the right range? You could verify by adding this line just prior to search:

Please Login or Register  to view this content.

Thank you a lot for your answers
Leelnich : yes the search applies to the right range
Winon : thank you for providing the excel file.
I do not want to have to add columns with "day/month" and "month/year" combinations. However, your file was VERY USEFUL because it enabled me to find a partial explanation to the problem.

It has to do with whether Excel detects the column to be a date column or not.
In order to know if it does, filter the column and if Excel proposes chronological filters, it means it detects it as a date column. If it only proposes textual filters, then the column is not regarded by Excel as a date column.
Now what I am trying to achieve with my Range.Find works fine if the column is not detected as a date column. I found this out because in Winon's file, the first column with what looks like DD/MM/YYYY dates is considered text by Excel.
Now if anyone knows how to force Excel to consider a column as a textual columns, THAT WOULD SOLVE MY PROBLEM.
Thank you !

PS Concerning filtering the column, for example with a criteria like "ends with 08/1980" : this does not work if the column is considered a date column. It works if the column is considered a textual column

Thank you Winon, I really appreciate your efforts, and your Excel file is very well designed !
But . . . in fact the column of dates in which the search is made is viewed by Excel as text cells, and therefore indeed the search for a partial string, or filtering on a partial string works.
I have transformed the file so that the dates are seen as dates, and the search does not work any more
So the problem is not really solved yet !
But thank you for your efforts !

Thank you again Winon
Please find enclosed a simple excel file
In the Blue Search In box, select either of two date columns
In the blue Search What box, type in something like "15-oct"
You will see that the search works in the Payment date column and not in the Order date column
The Payment date column is seen as a text column whereas the Order date column is seen as a date column
Hope you understand what I was trying to achieve
Jean-Marie