Browse subsubfolders and check name

[Nelson78]

Hello everybody.

I've a folder named "Codes":

C:\Users\john.smith\Desktop\Codes

Inside the folder, I have a bunch of subfolders (unzipped and zipped). It's important to say that I can't know their name a priori.

For example:

C:\Users\john.smith\Desktop\Codes\zzzzz
C:\Users\john.smith\Desktop\Codes\yyyyy
C:\Users\john.smith\Desktop\Codes\wwwww

Inside these subfolders, I have other subfolders.

For example:

C:\Users\john.smith\Desktop\Codes\zzzzz\aaa
C:\Users\john.smith\Desktop\Codes\zzzzz\bbb
C:\Users\john.smith\Desktop\Codes\yyyyy\rrr
C:\Users\john.smith\Desktop\Codes\wwwww\ppp
C:\Users\john.smith\Desktop\Codes\wwwww\nnn
C:\Users\john.smith\Desktop\Codes\wwwww\ccc
C:\Users\john.smith\Desktop\Codes\wwwww\kkk

Now, in the end of previous operations I got a range in my Excel sheet whose name is

rng

The job is:
1) Check if the subsubfolders name (aaa bbb rrr ppp nnn ccc kkk) matches one of the values in rng.
2) If yes, copy the subsubfolders and paste in

C:\Users\john.smith\Desktop\copied

Could you help me?

Thank's.