Hi I am attempting to create sub folders using the value in a cell which is "Nikki jules\Fallen Kingdom\night watch" but every time i run the macro it says folder path not found 76. I even tried it Mkdir.
folder1 = Range("G1").Value 'G1 value is Nikki jules\Fallen Kingdom\night watch
NewFolder = "C:\Users\Paul\Documents\Battle wars\" & folder1
so can someone please give me a solution and the reason why it doesn't like it.