Rename folders using values from sheet

Hi all,

I have a list of reference numbers in column A, and an address in column B.

Along with that - i have a folder which contains loads of folders named with the reference numbers. Is there a way using VBA, that i can go through each cell in column A and perform the following:

Go through each reference number in column A, check if there is a folder with that name, if so - rename with the corresponding value in column B.

I hope i have explained this correctly

You can try with this code:

Please Login or Register  to view this content.

Regards,
Antonio

Hi,

I should have said that i have around 300 rows so i would need to perform this for each row. Any ideas?

Thanks again!

That's exactly what i needed!!

Thank you VERY MUCH!!!