Hi all,

I'm new to VBA and even newer to this forum (first post). I'm trying to write a macro that mainly does two things: 1) create a windows explorer folder and name it according to each cell in a column, and 2) link each cell to its corresponding folder. I have sucessfully done the first, and can do the second but only for one cell at a time.

So here's the question: How can I loop the code so that it creates a separate link for each cell?

The part that's stumping me is that the cell contents is only the destination of each path.

Example: I'm practicing this on a much smaller sheet before applying it to the large tracker at work I plan to implement it to. So right now I have a simple spreadsheet, just a list of useless folders (Folder1, Folder2, ... , Folder7) The macro now creates these seven folders in my C: drive, so the path for Folder1 is C:\Folder1 (super simple, I know, just bear with me) What I want to do is have the macro link each cell to the folders it just created, instead of manually inputing the path for every one.

So how do I create a macro that can write a link to a custom path for each cell at once? .. the destination of each path being the cell contents.

Thanks for your help, and sorry for the wall of text!

-Mike