Hi,

New around here and not much of a VBA programmer, but hope you can help me
out.

I want to create a macro in Excel that will use the MkDir function to create
directories based on values contained in two columns. The values in Column A
define the 1st level directory and those in Column B define the 2nd level
directory.

For example:

The following data in columns A and B of the spreadsheet:

A B
one aaaa
one bbbb
one cccc
two dddd
two eeee
two ffff

Would create the following directories:

€¦\one\aaaa
€¦\one\bbbb
€¦\one\ccc

€¦\two\dddd
€¦\two\eeee
€¦\two\ffff

Any help would be greatly appreciated!

--
Thanks,
Tom