Help!! Output list of folders to particular cell

Hi, Need some help with my VBA as I'm new to all this.

I have so far made some code which will look at a folder, that is selected in cell B1, and then create a list of all the folder names inside that folder and then turn all of the names into hyperlinks to the folder in question. The problem comes when I change folders which will happen every month.

Is it possible to output this list of folders to a pre-defined cell that could be set in excel, say cell D1, so that when the folder is changed every month they will not overwrite the previous months folder names. I have tried this twice but failed each time.

Thanks for any help in advance.

Below is the code I have written so far.

Please Login or Register  to view this content.

Please edit your post, refer to rule#3 of the forum rules:


3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button). The result will appear like this in the post window:

[code ]Please Login or Register to view this content.[/code]

You can also type the code tags in manually if you prefer. For more information about these and other tags, click here.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member.

Ok, thank you for editing that. Would it work if you just had the folder names with links added to a growing list?

You could do that by changing one line of code there:

This line:

Please Login or Register  to view this content.

Becomes:

Please Login or Register  to view this content.

That should do it - it will find the next blank row to place the link. I used the WS.CELLS() instead of the RANGE() you were using - that is just how I would do that. The key step is finding the bottom row and offsetting by 1 row.