create new folder at one location and copy photos in that folder from other location

Hi Friends,

I'm trying to create a new folder and copy all the files present in photos folder to the newly created folder. I will be grateful to you if you can help me with this issue. Hope the issue is understood.

I tried some coding here, but it is not working... pls look into the code as below:

Please Login or Register  to view this content.

'i' should be declared as an integer, not a string.

ActiveCell needs to change for each value of 'i', I presume, so use:

Please Login or Register  to view this content.

Where X refers to your column and Row, depending on which one is relevant then one should be static and one should be replaced with i, for example if all your filenames are in column A, starting in row 1 to 10, then:

Please Login or Register  to view this content.

Hope that helps.