On Oct 23, 11:25 am, "Rick Rothstein \(MVP - VB\)"
wrote:
Exactly what do you mean by "cell A1 is assigned to 1st folder in C"? Do you
mean you want to rename the folder (as your Subject line seems to indicate)
or do you have something else in mind when you say "assigned"? Also, what do
you mean by 1st folder, 2nd folder, etc. To the best of my knowledge,
folders don't really have a predictable "order" to them.

Rick

wrote in message

ups.com...



I have 56 values in A1:A56 and 56 folders (1,2,3.....56) in C: drive.
Can a macro be written such that in a single click the the value in
cell A1 is assigned to 1st folder in C:, cell A2 value assigned to 2nd
folder, A3 value assigned to 3rd folder etc....

If yes, please let me know the macro to accomplish this. Thanks- Hide quoted text -

- Show quoted text -

Rick, Anon that was not a well-written question. I admit.

Okay, I have 40 folders named 1, 2, 3, 4... 40.. The folders are in
C:

The folder named 1 should be renamed by the text/value in cell A1.
The folder named 2 should be renamed by the text/value in cell A2.

I hope you got it.