Search only for specific word

[ProfMonteiro]

I hope I can explain my doubt.
I have a directory where it contains several folders but only interest me the folders with the names Notes 2013, Notes 2014 ... Notes 2019
I have a D3 cell that, when I put it, for example, 2018, it returns all subfolders inside Notes 2018.
What I intended is when cell D3 is empty, return everything with the name Notes (Notes 2013, Notes 2014 ... Notes 2019) and not the rest of the folders with other names.
My problem is in the second IF
Can anyone help?

My Code:

Please Login or Register  to view this content.

Thank's again!

[AlphaFrog]

Please Login or Register  to view this content.

[ProfMonteiro]

Thank you for helping me.

Unfortunately it's still not working

When the D3 folder is empty, instead of just giving the main folder name (Note 2017, Note 2018, Note 2019 ...) it is returning all the folders inside the main folders ...
For now, i just want to return the name of the main folders.

Other small bug's I found

If, for example, the folder Notes 2017 only has a folder in it, it gives the error "Run-Time error" 9 "- Subscript out of range" on "Resize (UBound (MyArr, 1) UBound (MyArr, 2)) Value = MyArr "
With to folders inside its ok and dont show the error

Another bug, if i sabe and re-opened the excel he gives the error here "Set objFolder = objFSO.GetFolder (strMainFldr)"

Thanks again.

Sorry jeffreybrown - Forget the code tags!