Hello all,

I've seen various Macros that will list files in a Directory. I'm looking
for a Macro that will list subdirectories in a directory. I would like the
Macro result printed to a blank sheet in a single column just containing the
sub-directory name. It only needs to go down 1 level - don't need
sub-directories in sub-directories. The plan is to use this data to populate
a listbox - unless the listbox could be populated directly.

Is this possible?

Many thanks.

Paul.