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