How to create multiple directories from cells using a macro or VBA

I have a very long list of numbers that I want to create directories for in a main shared network drive. I have found multiple HELP threads on the topic of how to create one directory and have made that work, but somehow need to be able to progress through the rows of cells in order to create multiple directories, in order to avoid having to create these directories manually. The VBA code I copied from a previous thread is as follows:

Please Login or Register  to view this content.

As mentioned, this works to create one directory, but, as per the attached sample worksheet, I need to be able to progress down the rows of cells from B3 to B4, etc.

Any help/suggestions or appropriate code would be very much appreciated.

Welcome to the forum, riskmgr! Modified sub:

Please Login or Register  to view this content.

See attached book for testing.