Macro to list folder names within a directory

Hi guys,

Thanks for all the help recently but I am not yet done! Now i'm looking for a macro which within a sheet named "foldernamedump" will list in a column the folder names within a directory I specify.

I have seen a couple of sample codes but I just cant seem to get them working at all so I think its best to start from scratch and the work i get supplied here is always perfect.

I also want the macro to clear the contents of the sheet before it loads again just to ensure there is no old data within the sheet.

Thank you for any help