Have you had a look at Chip's brilliant site
www.cpearson.com/excel/foldertree.aspx
?

On Mar 17, 1:18*pm, Andrew wrote:
Can someone show me how to write a code which will find all the
folders in a given directory and then write those folder names onto
the active worksheet? *I know how to do files, I just need the
folders.

thanks,
Andy