Search for a match files using value from selected cell in Folder or Subfolders

[ZerP]

Hi Mana and arnelgp,
Thanks for your suggestion, I change the code with this "myRange.Offset(0, 1).Value = Application.Transpose(arrNames)" and it works, I just use excel formula to separate the string to individual column.

The issue is it takes longer to search and print the result.

Annotation 2022-10-12 162647.jpg
Annotation 2022-10-12 162646.jpg

I noticed that when I'm trying to search from 1 single folder directory it load fast but when the directory contains multiple subfolders it took me 3 mins to search 25 file.
But for now I'll make used of it as long as it works.

Thanks you all so much for your time and assistance.