Creating folderpaths based on variables

In post #2 I gave a "suggestion" on how you would call this macro based on your original macro.

The MakeDirectories takes ONE parameter. It analyzes on long string and makes sure every folder exists, from the root directory all the way down to the final folder. The string should not include a file name, folders only.

So, based on your original macro I made a guess at how to construct that one long path string and gave that example in post #2.

So edit your macro to only pass one string. Your comma creates two string parameters, and only one is accepted. Give it another shot.

BTW, do not edit the UDF itself the way you did, you made it unworkable. Go back to the original macro. The UDF version is further down on the sheet, you took the wrong version.

Use the UDF version of that function, put it in the same module, then you can call it like so:

MakeFolders (MainPath & "Outputs\" & Region & "\" & Branch)

It will make every folder and subfolder in that path if necessary.