Is it possible to run a macro that will list the folder names within a
specified directory? Ideally I would like this to list all the folder names
into a single column.

Any help is hugely appreciated

Nick